date + working days

J

Jose

I need an easy way to obtain a new date form adding a current date with the
total number of working days in that period.

Im an unexperienced user.
Thanks
 
M

Martin Fishlock

Hi Jose.

Excel has got WORKDAY(start_date,days,holidays)

This takes the start day and adds days on to it assuming a 5 day week.

You can add holidays with the holdiays which is a list of cells like A3:A6
in the format of dates like 1/1/2007

If this function is not available, and returns the #NAME? error, install and
load the Analysis ToolPak add-in:
1.On the Tools menu, click Add-Ins.
2. In the Add-Ins available list, select the Analysis ToolPak box, and then
click OK.
3. If necessary, follow the instructions in the setup program.
 
M

Martin Fishlock

I forgot to mention,

Make sure the cells are formated as dates outwise there may be problems.

The formula returns the next day,

so if you use =WORKDAY(date(2007,1,3),1) it will return 4th Jan.
 
Top