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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating age from date of birth and ignoring if blank 5
"how do I calculate age by using date of birth details" 5
calculate date of birth with an end date and age 1
age 3
Excel if Functions 1
create calculated field for age in pivot tables 4
formula to automatically calculate customer age 1
#VALUE! - how to get rid of it? 2

Back
Top