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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Converting negative date values 3
question on correct formula to use. 4
Difference in Hours 4
How do I convert a serial number to the month, day, and year in E. 2
Anniversary...date calculations 3
date calculation 3
Prorating calculations in Excel 0
i can't get date serial # to show as date in formula 4

Top