Workdays issue

[Lorderon]

Hi,
In cell A1, i have the start date
In cell B1, i have the duraiton in working days

I want to put a formula in cell C1 to give me the date from the start date
(cell A1) given the difference shown in the duration (cell B1)..

Example:
Cell A1 = Jan 2, 2009
Cell B1 = 5 days
By right, cell C1 should be equal to Jan 9, 2009

How to do it? What formula to put in cell C1??

Thanks!

 

[Mike H]

Try

=WORKDAY(A1,B1)


Format as date

Mike

 

[Mike H]

I should have mentioned the 3rd argument for workday

=WORKDAY(A1,B1,Holidays)

Where 'Holidays' is a named range that contain holiday dates you wish to
exclude.

Mike

 

[Lorderon]

Thanks it works!

I should have mentioned the 3rd argument for workday

=WORKDAY(A1,B1,Holidays)

Where 'Holidays' is a named range that contain holiday dates you wish to
exclude.

Mike