DATEDIF Assume Today If Blank

[NewNewbie1]

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!

[gjcase]

Try replacing A2 with If(A2=0,Today(),0) inside the formula

[63falcondude]

Hello and welcome to the forum.

Try this:

=DATEDIF(A1,IF(A2="",TODAY(),A2),"Y") & "y, " & DATEDIF(A1,IF(A2="",TODAY(),A2),"YM") & "m "

[NewNewbie1]

You are awesome! That worked perfectly...thank you so much!

[63falcondude]

You're welcome. Happy to help.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.