counting the number or months between two dates.

  • Thread starter Thread starter Lisa
  • Start date Start date
Ok Maybe I did something wrong.

I used =DATEDIF(A1,A2,"ym")
with A1 as 4/30/2007
and A2 as 11/30/2008
result was 7

????????
 
If you want months only,use "m" instead of "ym"
"ym" is used when you strip off the year

y = year
ym = months after year(s) is removed
m = months
md = days after months have been stripped off
d = days but you might was well use end-start on that one

--


Regards,


Peo Sjoblom
 
my bad, sorry, I am so used to typing "ym" that i was on autopilot. See the
other 2 posts for corrections :)
 

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

Expanding Date formula 1
Count number of "Yes" between two dates 4
Count days between text dates 8
Access Count dates within a Month 4
Excel Date Count 2
Count Inbetween dates 3
Count Between dates 11
calculate number of months based on one date 1

Back
Top