Hi Everyone,
I am hoping someone may be able to help me with a DATEIF formula that I am trying to incorporate a "If Blank, Assume Today" into.
In the following example, if A2 is blank I would like Excel to assume today's date:
=DATEDIF(A1,A2,"Y") & "y, " & DATEDIF(A1,A2,"YM") & "m "
Thanks in advance!
Bookmarks