Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Which day are you comparing this to get 16? August 1st or July 31st?
August 1st
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
May be like this
=HolidayDate - MonthStart(HolidayDate) + 2
Is there any function available which could return me the date as weekend or holiday else return me the next working day ?
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.
May be use LastWorkDay function...
=LastWorkDate(MonthStart(Today(), 1), 12)
You can supply the list of holidays in there as well
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
I don't think there is a function available for this... you can use a nested if statement to check for weekends