Calculate Next Business Day

F

frpkaren

I have a beginning date, an ending date and need a return date. I can use a
formula to add one day to the ending date, but I need the return date to be a
business day (Monday thru Friday).

Beginning 3/21/05, ending 3/25/05, return 3/28/05. The ending date isn't
always on a Friday, so I can't just say to add 3 days.

Thanks
 
B

Bill Edwards

dtmNextWeekDay = IIf(Weekday(dtmEndDate) = 6, DateAdd("d", 3, dtmEndDate),
DateAdd("d", 1, dtmEndDate))
 
Top