| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculate difference between 2 dates
Hi
I have a tracking spreadsheet that contains all the deals with the close date change.. there's a close date old value in column A and a close date new value in column B is there a formula where i can use to determine if the change of date is within the quarter; pull in or push out of quarter ? Column A Column B Formula 28-Nov-2008 12-Sep-2008 Pull in 28-Nov-2008 20-Oct-2008 within the quarter 28-Nov-2008 10-Jan-2009 Push out of quarter Any help is appreciated, Thanks! -- nikko |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate difference in dates | Excel Discussion (Misc queries) | |||
| How do I calculate exact difference between two dates in y,m,d. | Excel Worksheet Functions | |||
| How do I calculate the difference between 2 dates (m,d,y) ? | Excel Worksheet Functions | |||
| Calculate Difference b/e 2 dates. | New Users to Excel | |||
| Calculate difference between two dates | Excel Worksheet Functions | |||
Threaded Mode
