Date Formula - calculate difference between two dates.

[reymon2012]

Good day, everybody.

On Column C , I used DAYS formula that calculates the difference between two dates in Column A and B. However, if possible, I would like to add a condition that states that if the difference between dates is less than one, the return value on Column C is one, and if the difference is greater than one, the return value is " 0."

Any assistance will be greatly appreciated.

 

[Macropod]

=(INT(A1-B1)>0)*1

 

[reymon2012]

=(INT(A1-B1)>0)*1

Just took a few tweaks to get it to work. =(INT(H187-F187)<=1)*1 .

Additional question though, I also need Col C to return a blank value if one of the columns A or B is blank.

Thank you Macropod. !!

 

[Macropod]

That's as simple as:
=IF(H187*F187=0,"",(INT(H187-F187)<=1)*1)

 

[reymon2012]

That's as simple as:
=IF(H187*F187=0,"",(INT(H187-F187)<=1)*1)

Great. Works perfectly. Thanks again !!!