| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Look At Two Dates
Have this formula: =MAX(DAYS360(R24,U24),0)
Now I need to add this: Even though this is totaling the days bewtween R24 and U24, if I put a date in S24 (this would override U24), I want the formula to total the days between R24 and S24. I need to keep the date in U24. It is the original work date. S24 would be a revised date. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| PivotTables - Group Dates, excluding dates | Excel Discussion (Misc queries) | |||
| US dates to UK?? | Excel Worksheet Functions | |||
| Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
| 2 digit year in dates return 19xx not 20xx | Excel Discussion (Misc queries) | |||
| Formating Dates for production schedule | Excel Discussion (Misc queries) | |||
Threaded Mode
