adding work days

  • Thread starter Thread starter Melissa
  • Start date Start date
M

Melissa

I'd like to use Excel to develop a project schedule. Is
there a way to add, for example, 3 work days to a
particular date? I know I can add 3 to any date and Excel
returns the date that is 3 days later, but I don't want to
include weekends. Is there a way to do this calculation?
Thanks for your help.
 
Look at the ATP function WORKDAY,

=WORKDAY(Startdate,#workdays,holidays)

If you get a name error do tools>add-ins and check Analysis ToolPak, keep
the excel/office cd handy and follow the instructions..

Help explains it pretty good

in A1 10/01/03, say you want to add 30 workdays

in B1:B10 list all holiday dates and the formula could look like

=WORKDAY(A1,30,B1:B10)

returns 11/13/03 I assumed you are a US federal worker with 10/13 as holiday
<g>
 
Check out this two functions in the Excel help

WORKDAY(start_date,days,holidays)

Returns a number that represents a date that is the indicated number of working days before or after a date (the starting date).
Working days exclude weekends and any dates identified as holidays. Use WORKDAY to exclude weekends or holidays when you
calculate invoice due dates, expected delivery times, or the number of days of work performed.

If this function is not available, and returns the #NAME? error, install and load the Analysis ToolPak add-in.


NETWORKDAYS(start_date,end_date,holidays)

If this function is not available, and returns the #NAME? error, install and load the Analysis ToolPak add-in.

How?

On the Tools menu, click Add-Ins.
In the Add-Ins available list, select the Analysis ToolPak box, and then click OK.
If necessary, follow the instructions in the setup program.
Syntax
 
Back
Top