Subtracting 2 dates

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

Birthday = 5/1//1946

I am using a formula to get the age of a person =(TODAY()-Birthday). This
returns a number 22272. I know that I can format that number and return the
correct year - 60. But I want to calculate off of that number. I am doing
an IF this year = certain age, I will get a certain text script.

But my formula does not see the =(TODAY()-Birthday) as a 60. How do I show
an age in years that can be calculated from?

Thanks

Dave
 
=DATEDIF(Birthday,TODAY(),"y")

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Hi Dave,

If you use the following formula to calculate the age it will return a value
in years:

=ROUNDDOWN((TODAY()-A2)/365.22,0)

You should then be able to do an IF function on this value.

All the best

Paul
 
Thank you - that did the trick!!

Dave


Bob Phillips said:
=DATEDIF(Birthday,TODAY(),"y")

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)
Click to expand...
 
Back
Top