I finally got the second one to work by adding a column with the start date
and working the formula off that cell. Then I just hid that extra column so
it would not show in my presentation. Thanks again. Big Help!
--
xintrigue


"Sheeloo" wrote:

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