LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 21
Default Excel - Calculate age from DOB in years, months days

Might seem obvious but I can't find an answer in Excel Help. I am trying to
calculate age in years, months and days by subtracting cell containing date
of birth from cell containing today function. Using 2007.
Many thanks.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
CALCULATE THE ACTUAL AGE IN TERMS OF YEARS, MONTHS AND DAYS jr Excel Worksheet Functions 2 January 23rd 12 05:19 PM
HOW DO I CALCULATE THE YEARS MONTHS AND DAYS BETWEEN SEVERAL DATE Susan Excel Discussion (Misc queries) 1 June 29th 06 02:27 PM
how do i calculate age in term of years, months, days shan Excel Worksheet Functions 1 March 15th 06 10:21 AM
how do i calculate age in term of years, months, days shan Excel Worksheet Functions 3 March 15th 06 05:58 AM
Function to calculate the number of years, months and days between Vicky Excel Worksheet Functions 2 July 15th 05 04:27 AM


All times are GMT +1. The time now is 01:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"