calculate age from today's date (changes daily) and birthdate
 

I work at a database involving "client age today" -- How can I get Excel to
calulate this for me when I by provide only the birthdate of the client; keep
in mind 'today's date' changes each day. I don't want past client entry ages
to change once entered, I just want to calculate today's client's age.

I subtracted today from the birthdate, divided by 365 but got fractions
which round up -- making a person older. . .and 'todays' date is going to be
different each day.

Suggestions? Leap year?

calculate age from today's date (changes daily) and birthdate
 

Hi

=DATEDIF(start date, end date,"y")
so if birthday is in A1 and todays date in B1 then:
=DATEDIF(A1,B1,"y")

HTH
Jean-Guy

"Milkmaiden" wrote:

I work at a database involving "client age today" -- How can I get Excel to
calulate this for me when I by provide only the birthdate of the client; keep
in mind 'today's date' changes each day. I don't want past client entry ages
to change once entered, I just want to calculate today's client's age.

I subtracted today from the birthdate, divided by 365 but got fractions
which round up -- making a person older. . .and 'todays' date is going to be
different each day.

Suggestions? Leap year?

calculate age from today's date (changes daily) and birthdate
 

If the date of birth is in B1 and =TODAY() is in A1 then:

=DATEDIF(B1,A1,"y") & " years, " & DATEDIF(B1,A1,"ym") & " months, " &
DATEDIF(B1,A1,"md") & " days"
--
Gary's Student


"Milkmaiden" wrote:

I work at a database involving "client age today" -- How can I get Excel to
calulate this for me when I by provide only the birthdate of the client; keep
in mind 'today's date' changes each day. I don't want past client entry ages
to change once entered, I just want to calculate today's client's age.

I subtracted today from the birthdate, divided by 365 but got fractions
which round up -- making a person older. . .and 'todays' date is going to be
different each day.

Suggestions? Leap year?

calculate age from today's date (changes daily) and birthdate
 

Hi

Here is a quick way to enter today's date into a cell in you didn't
know....... CTRL+;

HTH
Jean-Guy

"Gary''s Student" wrote:

If the date of birth is in B1 and =TODAY() is in A1 then:

=DATEDIF(B1,A1,"y") & " years, " & DATEDIF(B1,A1,"ym") & " months, " &
DATEDIF(B1,A1,"md") & " days"
--
Gary's Student


"Milkmaiden" wrote:

I work at a database involving "client age today" -- How can I get Excel to
calulate this for me when I by provide only the birthdate of the client; keep
in mind 'today's date' changes each day. I don't want past client entry ages
to change once entered, I just want to calculate today's client's age.

I subtracted today from the birthdate, divided by 365 but got fractions
which round up -- making a person older. . .and 'todays' date is going to be
different each day.

Suggestions? Leap year?

calculate age from today's date (changes daily) and birthdate
 

The shortcut you mentioned is also nice and static...the cell won't change
tomorow.
--
Gary's Student


"pinmaster" wrote:

Hi

Here is a quick way to enter today's date into a cell in you didn't
know....... CTRL+;

HTH
Jean-Guy

"Gary''s Student" wrote:

If the date of birth is in B1 and =TODAY() is in A1 then:

=DATEDIF(B1,A1,"y") & " years, " & DATEDIF(B1,A1,"ym") & " months, " &
DATEDIF(B1,A1,"md") & " days"
--
Gary's Student


"Milkmaiden" wrote:

I work at a database involving "client age today" -- How can I get Excel to
calulate this for me when I by provide only the birthdate of the client; keep
in mind 'today's date' changes each day. I don't want past client entry ages
to change once entered, I just want to calculate today's client's age.

I subtracted today from the birthdate, divided by 365 but got fractions
which round up -- making a person older. . .and 'todays' date is going to be
different each day.

Suggestions? Leap year?