Find the number of months

[RodneyW]

In column B I have dates entered and displaying in this format 1/4/2023. In column C I have a similar date, lets say its 3/7/2023.

B1 = 1/4/2023
C1 = 3/7/2023

In D1 I want it to tell me the number of days (not months as the subject head suggests) between the value in B1 and C1

Thanks in advance

 

[Anfinsen]

Book1
	A	B	C	D
1		1/4/2023	3/7/2023	62
2
Sheet1

Cell Formulas
Range	Formula
D1	D1	=C1-B1

 

[RodneyW]

Book1
	A	B	C	D
1		1/4/2023	3/7/2023	62
2
Sheet1

Cell Formulas
Range	Formula
D1	D1	=C1-B1

That was easy, thanks

 

[Anfinsen]

I wish they were all that easy