Formula needed to calculate days between two dates, but need 0 if one cell is blank

[jengoz]

Hi there, this is my first time posting here! I would appreciate any help with the following:

I need to calculate days between two dates in two cells, but if one of those two cells is blank, I want the cell with the formula to remain blank or 0.

Example:

A4 has todays date: 1/18/17
C17 has the date of 12/31/16
I want cell E17 to tell me the number of dates between these two dates. But I also want this formula to have E17 be blank or zero if C17 were blank.

Can anyone help me with this? Thank you in advance!

 

[Tetra201]

Try this:

=IF(C17="","",ABS(A4-C17))

 

[jengoz]

OMG! That worked perfectly! Okay one more questions...so now, I have this forumal in E17 =F17/30*E17, which uses the answer from C17 formula =IF(C17="","",ABS(A4-C17)) to give me a dollar amount. but when it is blank it gives me the VALUE error message. How can I change the formula in E17 to still calculate correctly if there is a date but be blank or zero if there isn't a date in C17?

I need to calculate vacancy loss. So here are the figures I am using:
A4 = 1/18/17
C17=1/1/17
E17 ==IF(C17="","",ABS(A4-C17))
F17 = f17 = Rent amount $500
G17 = F17/30*E17 - but if there is no date in c17 it gives me an error. How can I make it be blank or zero?

Thanks again for such a prompt response!

 

[Tetra201]

The easiest way is to use =IF(C17="",0,ABS(A4-C17)) in cell E17.

 

[jengoz]

This worked perfectly! Thank you so much!!!