Number of Months elapsed from start date

Bazzza

New Member
Joined
Jun 28, 2004
Messages
21
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
 

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
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

New Member
Joined
Jun 28, 2004
Messages
21
I did have the dates formatted

Many thanks PaddyD, just what I wanted...
 

Bazzza

New Member
Joined
Jun 28, 2004
Messages
21
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?
 

Forum statistics

Threads
1,078,246
Messages
5,339,064
Members
399,276
Latest member
Donjayok

Some videos you may like

This Week's Hot Topics

Top