if statements returning dates
See Excel help on the WORKDAY function.
It returns the date serial number n days if the future and has an option to
account for holidays.
You have to format the result as a date.
--
Biff
Microsoft Excel MVP
"Clinton" wrote in message
...
i have the following formula to give a 2 day cycle for production which
will
skip saturdays and sundays. can it be made to miss other days such as
public
holidays also if they are put into a table or something.
IF(WEEKDAY(A1+2)=7,A1+4,IF(WEEKDAY(A1+2)=1,A1+4,A1 +2))
whe A1 is first date, formula is in B1:Z1
|