Hi
use the WORKDAY function for this. you must have the
Analysis Toolpak installed for this


-----Original Message-----
Hi all, I am creating a worksheet which when the start
date is inputed,
the following dates will be created ( which is start date
plus so many
days). I need to specify that if these dates fall on a
sat or sun then
they must equal the following mon. It would be helpful,
if I could also
specify holidays etc, where the next working day is
created etc. I
would also like the day of the week displayed as well as
the date in
the same cell? ie Thurs 10 Jan 04.
Any help is appreciated.


---
Message posted from http://www.ExcelForum.com/

.