Subtract MM/DD/YYYY and get # months

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
=DATEDIF(start_date,end_date,"m") will give you the number of months between
start_date and end_date
 
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to convert MM/DD/YYYY to Month 2
Help with date format mm/dd/yyyy vs. dd/mm/yyyy 3
Returning the month (mmm) from cell in date format dd/mm/yyyy 1
Changing date to eliminate day in format mm/dd/yyyy 1
How to sum when the criteria and the range are in the same row? 2
Sumproduct and weekday from mm/dd/yyyy format? 3
change date format from dd/mm/yyyy to mm/yyyy 2
How I convert date formatt of dd/mm/yy to mm/yy (not cell format) 1

Back
Top