WORKDAY


Returns a date a given number of workdays away.

Syntax:

WORKDAY(startdate, days, hols_range)
returns the date that is days workdays after the given date startdate. days is a number (which may be negative to find a date before startdate). Saturday and Sunday are assumed to be non-working days. hols_range (optional) is a range containing dates of other non-working days.

Example:

WORKDAY("2008-09-05", 1)
returns the date-time serial number for Monday 8Sep08. 5Sep08 is a Friday.
WORKDAY("2008-09-05", 1, D1:D2)
where D1 contains 8 Sep 08 and D2 contains 25 Dec 08, returns the date-time serial number for 9 Sep 08. The 8 Sep 08 is specified as a holiday.






 
Created with Zapof