Calculating Nth day of month by excluding holidays and weekends

[farheenayesha]

Hi,

I am trying to calculate Nth day of fiscal Month for current and previous year using Invoice date by excluding hoildays and weekends. I want to create two fields as 'Nth Day by Month_PY ' and 'Nth Day by Month_CY'. Please find the data and holiday list attached. Help me to get the output similar to the output sheet in the attached excel.

Invoice Date	Nth Day of Month_PY	Nth Day of Month_CY
12/25/2017	21
12/26/2017	21
12/27/2017	22
12/28/2017	23
12/29/2017	24
12/30/2017	24
12/31/2017	24
12/24/2018		21
12/25/2018		21
12/26/2018		21
12/27/2018		22
12/28/2018		23
12/29/2018		23
12/30/2018		23

[farheenayesha]

Thank you so much Sunny 🙂 Both of you's logic is giving perfect output. thank you so much Jen and Sunny 🙂 You both have resolved my big problem 🙂 

This post was with respect to Month. I have posted another question in a separate thread for Quarter and year. Please help me to resolve it. Please find the thread link below.

https://community.qlik.com/t5/QlikView-App-Development/Calculating-Nth-day-of-Quarter-amp-Year-by-ex...