Adding workdays as part of the equation

  • Thread starter Thread starter DavidJ726
  • Start date Start date
D

DavidJ726

I'm trying to put together a simple schedule in Excel and need to calculate
x working days from a given date. So if cell A1 = the project start date,
and I need the date in B1 to show the completion date of 13 working days
later, is it possible to do that without having to have a seperate cell
containg the # of workdays?

Thanks,
 
Hi David

Provided you have the Analysis Toolpak loaded, Tools>Addins>check Analysis
Toolpak, then
=WORKDAY(A1,13)
will give your result.

If you want to include holidays, then
=WORKDAY(A1,13,$B$1:$B$12)
where B1:B12 holds a list of holiday dates or create a named range for the
holiday dates (holidays)and use
=WORKDAY(A1,13,holidays)
 
Thanks Roger,
Exactly what I needed!

Roger Govier said:
Hi David

Provided you have the Analysis Toolpak loaded, Tools>Addins>check Analysis
Toolpak, then
=WORKDAY(A1,13)
will give your result.

If you want to include holidays, then
=WORKDAY(A1,13,$B$1:$B$12)
where B1:B12 holds a list of holiday dates or create a named range for the
holiday dates (holidays)and use
=WORKDAY(A1,13,holidays)
Click to expand...
 
Back
Top