Thread: Date Formulas
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Teri[_2_] Teri[_2_] is offline
external usenet poster
 
Posts: 3
Default Date Formulas

I've been asked to create a spreadsheet that calculates a
persons age.

I have two columns (Birthdate & Hire Date), and need a
formula to figure out a persons age in years and months
(another 2 columns).

The one catch is if the person is born before the 15th of
the month, then count that month. If they're born on the
15th or after, then don't count that month.

Any help would really be appreciated.

Thanks,

Teri