Weekend dates

[bresam]

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 man
days). I need to specify that if these dates fall on a sat or sun the
they must equal the following mon. It would be helpful, if I could als
specify holidays etc, where the next working day is created etc.
would also like the day of the week displayed as well as the date i
the same cell? ie Thurs 10 Jan 04.
Any help is appreciated

 

[Frank Kabel]

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

 

[Bob Phillips]

For the second part, format the cell. You can't have Thurs, but you can have
Thu (ddd dd mmm yy) or Thursday (dddd dd mm yy)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)