Conditional formula for date calculations

Evilbite

New member
Joined
Dec 18, 2012
Messages
1
Reaction score
0
Points
0
I am trying to construct a formula to calculate the number of days between 2 dates. If cell A1(starting date) is blank, return "0". If cell B1 (end date) is blank, return the difference between A1 and today's date. I have this: =ABS(TODAY()-E7)
 
Top