Thread: Formula problem
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Sheeloo Sheeloo is offline
external usenet poster
 
Posts: 793
Default 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