| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cycle Time if in a Specific Year
I am trying to calculate the time between 2 dates, if the latter date
occurred in 2007. Here is where I was going, but it doesn't seem to work. =IF(H2=YEAR(L2),(H2-E2),"") where L2 has the value 2007. Also, how would it change if I wanted H2 beween 2 years, ie. 2004-2006. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cycle time out of range error | Excel Discussion (Misc queries) | |||
| Time Cycle | Excel Discussion (Misc queries) | |||
| Format Help BOLD year in a specific vehicle application Column | Excel Worksheet Functions | |||
| How do I keep result from 1 iteration cycle to use in next cycle? | Excel Discussion (Misc queries) | |||
| entering items on specific dates of year | Excel Discussion (Misc queries) | |||
Threaded Mode
