I have a date that I would like to add 28 working days to. I don't want to
include the weekend days in the calculations. So May 19, 2008 plus 28
working days would be ???? I need a formula for my worksheet. Can you help.

=workday(a1,28)
(where a1 contained the May 19, 2008 date)

But if you're using xl2003 or below, you'll need to have the Analysis toolpak
loaded (under tools|Addins).

Excel's help for =workday() has more info.

Pfizer Gal wrote:

I have a date that I would like to add 28 working days to. I don't want to
include the weekend days in the calculations. So May 19, 2008 plus 28
working days would be ???? I need a formula for my worksheet. Can you help.

--

Dave Peterson

A1 = 5/19/2008

=WORKDAY(A1,28)

Format as DATE

See Excel help on the WORKDAY function.

--
Biff
Microsoft Excel MVP


"Pfizer Gal" <Pfizer wrote in message
...
I have a date that I would like to add 28 working days to. I don't want to
include the weekend days in the calculations. So May 19, 2008 plus 28
working days would be ???? I need a formula for my worksheet. Can you
help.

=WORKDAY(A1,28) and format the result to suit.
--
David Biddulph

"Pfizer Gal" <Pfizer wrote in message
...
I have a date that I would like to add 28 working days to. I don't want to
include the weekend days in the calculations. So May 19, 2008 plus 28
working days would be ???? I need a formula for my worksheet. Can you
help.