Date Calcuation with Blank Cells
Hope this does what you want:
=IF(E2="",6,DATEDIF(E2,TODAY(),"m"))
Regards,
Ryan---
--
RyGuy
"PT40" wrote:
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
|