If Formulas

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
 
A

Arvi Laanemets

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

Display weeks from a Milestone 0
Adding another if statement to an index formula 0
calculate average values for 100 records in the shortest way? 5
calculate date of birth with an end date and age 1
Date Functions 5
ASK Field Formatting 1
New computer, how do i move outlook 365 ENTIRELY? 0
create calculated field for age in pivot tables 4

Top