ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Calculating age (https://www.excelbanter.com/excel-discussion-misc-queries/259473-calculating-age.html)

Chris Waller

Calculating age
 
I have a Spreadsheet that contains a column of dates (birthdays and
anniversarys)in the dd/mm/yyyy format. Across row 1 I have the years 2010,
2011, 2012 etc. At the intersection of the two I wish to insert a formula
that will calculate the age or the anniversary. I would be grateful for any
help. Thanks in advance.

Fred Smith[_4_]

Calculating age
 
See your other post.

Regards,
Fred

"Chris waller" wrote in message
...
I have a Spreadsheet that contains a column of dates (birthdays and
anniversarys)in the dd/mm/yyyy format. Across row 1 I have the years 2010,
2011, 2012 etc. At the intersection of the two I wish to insert a formula
that will calculate the age or the anniversary. I would be grateful for
any
help. Thanks in advance.




All times are GMT +1. The time now is 03:02 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com