Excel function help

Lee Douglas · 07-22-2008, 09:58 AM

Hey people, I have a spreadsheet containing names and dates of birth, I want to be able to calculate the age from the DOB, any ideas on a function or formula to do this?

**Glaswegian** · 07-22-2008, 12:44 PM

Hi

Formulae are not my thing, so I'm sure there's a much better way of doing this, but try

=(NOW()-A1)/365

David M58 · 07-22-2008, 02:31 PM

Another way (with date of birth in cell A1):

=DATEDIF(A1,TODAY(),"Y")

Lee Douglas · 07-23-2008, 04:55 AM

If anybody is interested, after some experimentation I went with the following.

=DAYS360(D4,F1,TRUE)/360

Cell F1 contains todays date, I just could not get 'TODAY' working. D4 contains the DOB, the DAYS360 function displays the differance in days between the two dates specified. The cell in which the formula was created was formated for a number with no decimal points, works like a charm.

Thanks though people.

David M58 · 07-23-2008, 05:28 AM

You're welcome.

Remember that the DAYS360 function is based on a 360-day year (twelve 30-day months).

07-22-2008, 09:58 AM	#1 (permalink)
Lee Douglas Registered User Join Date: Feb 2008 Posts: 12 OS: WinXP	Excel function help Hey people, I have a spreadsheet containing names and dates of birth, I want to be able to calculate the age from the DOB, any ideas on a function or formula to do this?

07-22-2008, 12:44 PM	#2 (permalink)
Glaswegian Moderator/ Rangemaster TSF Academy; Analyst, Security Team; Oor Wullie; TSF Surgeon and Resident Comic Join Date: Sep 2005 Location: Glasgow Posts: 21,016 OS: Win XP Pro SP3 My System Blog Entries: 9	Re: Excel function help Hi Formulae are not my thing, so I'm sure there's a much better way of doing this, but try =(NOW()-A1)/365 __________________ Iain - Defender of the Haggis and all things Scottish. I don't help by PM - post in the Forums. Ad-Aware::SpywareBlaster::SpyBot::SpywareGuard::SnoopFree::AVG Free::HOSTS File::HijackThis::Donate::5 Steps For Infected PCs

07-22-2008, 02:31 PM	#3 (permalink)
David M58 Registered User Join Date: May 2008 Location: Baltimore, Maryland Posts: 94 OS: Windows XP SP3	Re: Excel function help Another way (with date of birth in cell A1): =DATEDIF(A1,TODAY(),"Y")

07-23-2008, 04:55 AM	#4 (permalink)
Lee Douglas Registered User Join Date: Feb 2008 Posts: 12 OS: WinXP	Re: Excel function help If anybody is interested, after some experimentation I went with the following. =DAYS360(D4,F1,TRUE)/360 Cell F1 contains todays date, I just could not get 'TODAY' working. D4 contains the DOB, the DAYS360 function displays the differance in days between the two dates specified. The cell in which the formula was created was formated for a number with no decimal points, works like a charm. Thanks though people.

07-23-2008, 05:28 AM	#5 (permalink)
David M58 Registered User Join Date: May 2008 Location: Baltimore, Maryland Posts: 94 OS: Windows XP SP3	Re: Excel function help You're welcome. Remember that the DAYS360 function is based on a 360-day year (twelve 30-day months).