| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Difference Calculations
trying to do a days in process formula, date requested date completed and if
date completed is not yet filled in getting serial # 39,887 +- I'd like to have either nothing or that number show as 0. I want to copy this formula into SharePoint list as calculated value when completed in Excel. Thanks Judy |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date Difference Calculations
Date Requested in A1 Date Completed in A2 This in the cell you want the answer..... =IF(A2="",0,A2-A1) Vaya con Dios, Chuck, CABGx3 "Judy" wrote: trying to do a days in process formula, date requested date completed and if date completed is not yet filled in getting serial # 39,887 +- I'd like to have either nothing or that number show as 0. I want to copy this formula into SharePoint list as calculated value when completed in Excel. Thanks Judy |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Difference between last date of month and given date | Excel Worksheet Functions | |||
| Date Difference | Excel Worksheet Functions | |||
| Time difference calculations, daylight savings time, Excel | Excel Discussion (Misc queries) | |||
| Difference in dates calculations except between certain times. | Excel Discussion (Misc queries) | |||
| Calculating Difference Between Start Date & Time And End Date & Ti | Excel Discussion (Misc queries) | |||
Linear Mode
