Number of Months elapsed from start date

[Bazzza]

Hello All

I am struggling with a date function.

Cell A1 = Start Date "Mar 04"
Cell A2 = Current Month "Nov 05"

In Cell A3 I need to count how many months have elapsed from start month to current month.

Answer I would be looking for is 21

Many thanks

 

[Scott Huish]

Is that actually in the cell as text that way, or is it a formatted date?

 

[PaddyD]

On the assumption that the dates aregenuine date valuse, not the text strings 'Mar 04' etc:

=datedif(startdate,enddate,"m")

so:

=DATEDIF(A1,A2,"m")

 

[Bazzza]

I did have the dates formatted

Many thanks PaddyD, just what I wanted...

 

[Bazzza]

Hello again

I have realised the my previous question should have been worded better,
think using the term "elapsed" was misleading.

The formula given previously provides an answer of 20, but am looking for 21 so that the first month is counted..

Mar 04 - Month 1
Apr 04 - Month 2
May 04 - Month 3
..
..
..
Oct 05 - Month 20
Nov 05 - Month 21

Any other ideas?

 

[PaddyD]

=DATEDIF(A1,A2,"m")+1

?