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!
|