If Formulas

  • Thread starter Thread starter Qaiser Jamil
  • Start date Start date
Q

Qaiser Jamil

Please can anyone help me with if fomrulas, i want to
write one. Also i need the formula for working out age
once u date of birth is provided

thanks
 
Hi

1. With some number in A1
=IF(OR(A1="",A1=0),"nothing",IF(A1=1,"one",IF(A1=2,"two",IF(A1=3,"three","ma
ny"))))


2. With birthday in A1
=DATEDIF(A1,TODAY(),"Y")
returns age in years. More exact formula will be
=DATEDIF(A1,TODAY(),"Y") & " years " & DATEDIF(A1,TODAY(),"YM") & " months "
& DATEDIF(A1,TODAY(),"MD") & " days"


Arvi Laanemets
 
Back
Top