Date Difference Calculations

  • Thread starter Thread starter Judy
  • Start date Start date
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
 
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

Date calculation cell became #NAME?. 1
Nested IF formula question 3
How To Have A Cell Be Blank If... 2
Excel How to calculate in excel number of open actions that expired (older then today) 0
Trailing 30 days sum calculation with excel 1
Difference of two dates 3
Determine accuracy percentage between two dates 2
Date Value Error 6

Back
Top