=DATEDIF(start_date,end_date,"m") will give you the number of months between
start_date and end_date
--
Regards,
Dave
<!--


"Carole O" wrote:

I have a vacation earning chart where employees earn xx hours per pay period.
When they have worked over xx months, they earn yy hours per pay period. I
need a way to subtract their start date from the currend end-of-pay-period
date to see where they fall in the leave earning chart - the catch is the
answer has to be in months.

I'm using Excel 2003. Any ideas?

TIA,

Carole O