Last Business Date Of Month (Excluding Weekends & Holidays)

[jkpats12]

Hi everyone,

Looking for some assistance...again on setting up some code which would locate the last business date of the month.

Also this would need to exclude weekends & holidays (this is imperative to exclude these), if anyone can assist with this it would be greatly appreciated.

Thanks in advance

 

[Bodisathva]

Rural Guy already gave you the module to back up a number of workdays...so set your initial date to your target month +1 and back up one day. If you're looking for the last work day in June, start with July 1 and go back one work day.

 

[jkpats12]

Thank you I'll give it a shot