WORKDAY

WORKDAY —

WORKDAY (start_date,days[,holidays])

WORKDAY returns the date which is days working days from the start_date. Weekends and holidays optionally supplied in holidays are respected.

WORKDAY returns #NUM! if start_date or days are invalid.
This function is Excel compatible.

DAY(WORKDAY(DATE(2001,1,5),30)) equals 16 and

MONTH(WORKDAY(DATE(2001,1,5),30)) equals 2.