Formula problem
For years use
=datedif(birthday, today(),"y")
and for months
=datedif(dateofjoing, today(),"m")
repacle birthday and dateofjoining with actual dates or cell addresses where
these dates are available.
"xintrigue" wrote:
Can anyone come up with a formula for re-calculating age with every birthday
and also increasing the number of months of employment each month? I'm
assuming I have to calculate this in Excel before I can bring the worksheet
into PowerPoint...
Birthday Age Mths employed
11/20/1952 55 23
--
xintrigue
|