HELP

[Pfizer Gal]

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]

=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.

 

[David Biddulph]

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

 

[T. Valko]

A1 = 5/19/2008

=WORKDAY(A1,28)

Format as DATE

See Excel help on the WORKDAY function.