| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Net Workdays | Excel Discussion (Misc queries) | |||
| Workdays | Excel Worksheet Functions | |||
| determine workdays | Excel Worksheet Functions | |||
| Workdays Function | Excel Worksheet Functions | |||
| Workdays | Excel Discussion (Misc queries) | |||
Linear Mode
