Subtract MM/DD/YYYY and get # months

C

Carole O

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
 
D

David Billigmeier

=DATEDIF(start_date,end_date,"m") will give you the number of months between
start_date and end_date
 
D

Duke Carey

To answer your question with a question: What is a month?

Is it 28 days, 30, 31, or some other means of declaring a month?

It's probably a trivial question until you compare a start date on the 31st
of a month to a pay date on Sept 30, or Feb 28. Has the employee earned that
month of service?
 
Top