How do I calculate the date an employee will reach a specific age?
|
How do I calculate the date an employee will reach a specific age?
If you just want to add years, use
=DATE(YEAR(B1)+A1,MONTH(B1),DAY(B1)) where A1 holds the number of years, B1, the DoB. If you want years, months and days, put each in A1,A2,A3, and use =DATE(YEAR(B1)+A1,MONTH(B1)+A2,DAY(B1)+A3) -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "ruth4074" wrote in message ... |
All times are GMT +1. The time now is 02:25 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com