Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 43
Default Calculate age

I have an Excel Spreadsheet that contains a column of dates of birth in the
format of dd/mm/yy. Across row 1 I have the current year in column "C"
followed by 2011 in column "D" etc. What I am trying to do is calculate the
ages of all the people using the year of their birth and the years that
appear in row 1. I have posted this previously to this discussion group, but
I do not seem able to find the posting now. Thanks in advance.
 
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 time does not calculate Wanna Learn Excel Discussion (Misc queries) 4 August 19th 08 12:51 AM
IF THERE ARE 9 P AND 5 A IN A ROW THEN HOW TO CALCULATE SRINIVAS Excel Worksheet Functions 5 October 28th 07 09:52 AM
V.A.T how to calculate it pm_sam Excel Worksheet Functions 3 October 4th 07 01:53 AM
How to calculate Age Centrol Excel Discussion (Misc queries) 4 September 26th 07 03:58 AM
Calculate Jeff Excel Discussion (Misc queries) 2 June 17th 06 10:56 PM


All times are GMT +1. The time now is 05:38 PM.

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"