You're welcome!

--
Biff
Microsoft Excel MVP


"Clinton" wrote in message
...
thank you very much. worked perfect.

"T. Valko" wrote:

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