date + working days
 

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

date + working days
 

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.

--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"Jose" wrote:

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

date + working days
 

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.

--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"Martin Fishlock" wrote:

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.

--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"Jose" wrote:

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