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

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

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/

.

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)

"Frank Kabel" wrote in message
...
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/

.