Calculate difference between two dates in whole months

[Danjones23]

Hi all,

I'm after some help.

We have some dates of cases reported and want to work out how long they take in months for business reporting. Would it be possible for someone to help me with the formula. I have tried used DATEDIF and others like Round, but I'm confused!

My work computer doesnt allow me to do Mini Sheets so hopefully the image covers me.

Essentially I want Date Closed - Date of report in months as a whole number. The date should be in a whole number to include the month the case is closed. Where the date closed is the calendar after, the months would then be expected to cover across e.g. Dec to Jan =2.

Thanks in advance

 

[Kerryx]

Book1
	A	B	C
1	Date of Report	Date Closed	Time (Months)
2	04/01/2024	05/02/2024	1
3	29/04/2024	01/09/2024	4
4	22/05/2024	25/05/2024	0
5	14/06/2024	16/06/2024	0
6	20/09/2024	01/03/2025	5
7	30/10/2024	01/12/2024	1
8	08/11/2024	01/01/2025	2
9	04/12/2024	25/02/2025	3
10	10/12/2024	26/02/2025	3
11	12/12/2024	27/02/2025	3
12	11/12/2024	28/02/2025	3
13	24/12/2024	01/03/2025	2
Sheet1

Cell Formulas
Range	Formula
C2:C13	C2	=ROUND(YEARFRAC(A2,B2)*12,0)

 

[Candyman8019]

Try something like: =MONTH(B35)-MONTH(A35)+1

 

[Danjones23]

Book1
	A	B	C
1	Date of Report	Date Closed	Time (Months)
2	04/01/2024	05/02/2024	1
3	29/04/2024	01/09/2024	4
4	22/05/2024	25/05/2024	0
5	14/06/2024	16/06/2024	0
6	20/09/2024	01/03/2025	5
7	30/10/2024	01/12/2024	1
8	08/11/2024	01/01/2025	2
9	04/12/2024	25/02/2025	3
10	10/12/2024	26/02/2025	3
11	12/12/2024	27/02/2025	3
12	11/12/2024	28/02/2025	3
13	24/12/2024	01/03/2025	2
Sheet1

Cell Formulas
Range	Formula
C2:C13	C2	=ROUND(YEARFRAC(A2,B2)*12,0)

That works really well, thank you!