Calculation of next business day.

[shree909]

Hi,

for example i have a  date

I would like to calculate the next business day excluding  weekends and holidays.

I used the function

=date(FirstWorkDate(Date(DATE +1),1,$(vPublicHolidays)),'MM/DD/YYYY')

this works fine the issue is when i select the date which is falling on friday  for that  the next businesss day is showing as the same date or the date i selected..

[rustyfishbones]

Have you tried Networkdays

Something like this

NETWORKDAYS(TODAY()+1)

[swuehl]

I think you need to use LastWorkDate() instead:

=date(LastWorkDate((DATE +1),1,$(vPublicHolidays)),'MM/DD/YYYY')