Date Difference Calculations

J

Judy

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
 
C

CLR

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
 
Top