Difference Between Dates

[vicedo]

Guys please i have a little issue

The difference in months from 'January to December' is 12 months. I tried calculating the difference between this months using the DATEDIF function but I keep getting 11months instead.

Please how do i go about this.

Thanks and regards

 

[jeffreybrown]

That's because there are only 11 complete months between the two dates.

You would need to add 1 to get the 12.

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

DATEDIF Worksheet Function

 

[etaf]

try
=DATEDIF(B1,EOMONTH(C1,1),"M")

where B1 is startmonth and C1 is enddate

 

[vicedo]

Jeffrey, adding +1 will not work

 

[vicedo]

Etaf, that worked well

 

[jeffreybrown]

Jeffrey, adding +1 will not work

It will not work for your setup or it failed altogether?

Data Range

	A​	B​	C​	D​
1​	1/1/2015​	​	12​	C1:=DATEDIF(A1,A2,"m")+1​
2​	12/1/2015​	​	12​	C2:=DATEDIF(A1,EOMONTH(A2,1),"M")​

 

[GerryZ]

Try:
=DATEDIF(A1,A2,"ym")+1

 

[vicedo]

Yea Jeffrey it worked well. Thanks all