Nth Day from Calender

[manojkulkarni]

Hi Friends,

I need to identify nth working day in a calender for month, how can we achieve this ? Is there any built in functions available to identify ?

eg:

15th Day of August, which is Holiday so i should get out put as 16.

[sunny_talwar]

Which day are you comparing this to get 16? August 1st or July 31st?

[manojkulkarni]

August 1st

[arvind_patil]

Hi Manoj,

You have to pass master to the database where you need to pass all dates which have a holiday.

Then after you can achieve this.

Thanks,

Arvind Patil

[sunny_talwar]

May be like this

=HolidayDate - MonthStart(HolidayDate) + 2

[manojkulkarni]

Is there any function available which could return me the date as weekend or holiday else return me the next working day ?

[manojkulkarni]

Hi Sunny,

I think my question was not clear.

I am trying to get 12th day of month for calculation purpose, if 12th day of month falls on weekend /holiday then i should look for next working day.

[sunny_talwar]

May be use LastWorkDay function...

=LastWorkDate(MonthStart(Today(), 1), 12)

You can supply the list of holidays in there as well

lastworkdate ‒ QlikView

[manojkulkarni]

This will exclude weekends. I need irrespective of weekends, 12th day of Month. Only if 12th days falls on weekend then look for next date

[sunny_talwar]

I don't think there is a function available for this... you can use a nested if statement to check for weekends