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
[Table="class: grid"][tr][td] [/td][td]

A​

[/td][td]

B​

[/td][td]

C​

[/td][td]

D​

[/td][/tr]
[tr][td]

1​

[/td][td]

1/1/2015​

[/td][td]

​

[/td][td]

12​

[/td][td]

C1:=DATEDIF(A1,A2,"m")+1​

[/td][/tr]

[tr][td]

2​

[/td][td]

12/1/2015​

[/td][td]

​

[/td][td]

12​

[/td][td]

C2:=DATEDIF(A1,EOMONTH(A2,1),"M")​

[/td][/tr]
[/table]

 

[GerryZ]

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

 

[vicedo]

Yea Jeffrey it worked well. Thanks all