Date Calcuation with Blank Cells

P

PT40

Hello,

I am looking to see if this is possible. I have my present formula below.
What I would like to do is that if the date in E2 is blank then to default to
6, and if not, then perform this calculation.

=DATEDIF(E2, TODAY(), "m")

Thank you
 
R

ryguy7272

Hope this does what you want:
=IF(E2="",6,DATEDIF(E2,TODAY(),"m"))

Regards,
Ryan---
 
Top