Date Formulas
Thanks Steve,
I've tried the formula, but I only get a cell filled with
#########. Any suggestions?
Thanks again,
Teri
-----Original Message-----
Teri,
With the birthdate in A1
For the years
=DATEDIF(A1,NOW(),"y")
For the months
=DATEDIF(A1,NOW(),"m")-12*A1-IF(DAY(A1)14,1,0)
(watch for word wrap)
(add $ signs to make A1 absolute reference $A$1 if needed)
--
sb
"Teri" wrote in message
...
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
.
|