HELP

  • Thread starter Thread starter Pfizer Gal
  • Start date Start date
P

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