Age calculation

[vishwajeet_chakravorty]

Dear,
For the calculation of age I have to apply this function in D4 =DATEDIF(C4,TODAY(),"Y"). If the C4 is blank then D4 should be blank, in this situation how to modify this funtion?

 

[Aladin Akyurek]

Dear,
For the calculation of age I have to apply this function in D4 =DATEDIF(C4,TODAY(),"Y"). If the C4 is blank then D4 should be blank, in this situation how to modify this funtion?

It's:

=IF(C4="","",DATEDIF(C4,TODAY(),"Y"))