TIPS & TRICKS
To find
age of a person based on DOB,
=DATEDIF(A1,NOW(),"y")
& " years, " & DATEDIF(A1,NOW(),"ym") & "
months, " & DATEDIF(A1,NOW(),"md") & " days"
Eg: In A1 column
enter DOB in this format 31/08/1985 and in another cell enter this formula.
To remove
unnecessary spaces in the cell,
=trim (text)
===== SHYAM =====
No comments:
Post a Comment