Adding workdays as part of the equation

[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,

 

[Roger Govier]

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)

 

[DavidJ726]

Thanks Roger,
Exactly what I needed!

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)