Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good day experts,
Trust you guys are well. I have created a calendar, which excludes public holidays and weekends. Also have a column which give the row number for the month networkDays(CalendarStartmonth,CalendarDate). the issue I am having is that where ther e are 2 holidays in a row the number goes of. Example,
day 3 in january 2012 should be 05/01/2012, but I get the 04/01/2012. taking into account that the 1st was a sunday and 2nd a public holiday. The starting
date for January is the 03/01/2012 and the start number should be 1, instead it is 2.
Any Ideas?
Thank you
Kamiel
Hi, I have resolved the issue
thank you