Workdays issue
 

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!

Workdays issue
 

Try

=WORKDAY(A1,B1)


Format as date

Mike

"Lorderon" wrote:

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!

Workdays issue
 

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


"Mike H" wrote:

Try

=WORKDAY(A1,B1)


Format as date

Mike

"Lorderon" wrote:

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!

Workdays issue
 

Thanks it works!

"Mike H" wrote:

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


"Mike H" wrote:

Try

=WORKDAY(A1,B1)


Format as date

Mike

"Lorderon" wrote:

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!