LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Kathy
 
Posts: n/a
Default Converting dates to a number

What formula could I use to convert a date of birth into an age?, e.g.,
06/25/71, 33.

Yes, I know I can just subtract but is there a formula that can do it?

Marguerite
 
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
Stop numbers converting to dates. biglar85012 Excel Worksheet Functions 2 March 29th 05 06:09 PM
Counting the number cells between two dates Dave Excel Discussion (Misc queries) 3 March 16th 05 02:30 PM
Count the number of dates in a range that are earlier than today. DeborahS Excel Worksheet Functions 1 March 9th 05 01:54 AM
Where is DateDiff function in Excel 2002 ? Nigel Welch Excel Worksheet Functions 4 March 4th 05 03:18 PM
Total number of each month in a column of dates GeorgeF. Excel Worksheet Functions 1 November 19th 04 06:10 PM


All times are GMT +1. The time now is 08:10 AM.

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

About Us

"It's about Microsoft Excel"