Calculating y,m,d not including blanks

[Taiter]

Greetings,

I am trying to calculate the amount of time from a date (m/d/yyyy) to show # years, # month, # day but ignore cell if blank. The formula I am using is IF([@[BEGIN DATE-MIN ]]<>"",DATEDIF([@[BEGIN DATE-MIN ]],TODAY(),"y"), DATEDIF([@[BEGIN DATE-MIN ]],TODAY(),"y")&" year, ")&IF(DATEDIF([@[BEGIN DATE-MIN ]],TODAY(),"ym"), DATEDIF([@[BEGIN DATE-MIN ]],TODAY(),"ym")&" month, ","")&IF(DATEDIF([@[BEGIN DATE-MIN ]],TODAY(),"md"), DATEDIF([@[BEGIN DATE-MIN ]],TODAY(),"md")&" day","")

It works fine when IF([@[BEGIN DATE-MIN ]]<>"", is not used but it drops the year with it. What am I missing?

Appreciate any help.

 

[RoryA]

It looks like you should be using:

=IF([@[BEGIN DATE-MIN ]]<>"",IF(DATEDIF([@[BEGIN DATE-MIN ]],TODAY(),"y"), DATEDIF([@[BEGIN DATE-MIN ]],TODAY(),"y")&" year,"")&IF(DATEDIF([@[BEGIN DATE-MIN ]],TODAY(),"ym"), DATEDIF([@[BEGIN DATE-MIN ]],TODAY(),"ym")&" month, ","")&IF(DATEDIF([@[BEGIN DATE-MIN ]],TODAY(),"md"), DATEDIF([@[BEGIN DATE-MIN ]],TODAY(),"md")&" day",""),"")

 

[Taiter]

Thank you for the reply. Now it causes an error and highlights the "ym".

 

[RoryA]

Which "ym" (there are two) and what is the error message?