Calculate months between today and a month/year cells

[monkeyharris]

Hi,

Should be straight forward but i can't get it. I need G92 to calculate the difference between today and E & F being the month and year. Any ideas?

Copy of Zero Spends Finesse stand figures 2024.xlsx
	E	F	G
1	Stand Delivery Month	Stand Delivery Year	Stand Age (Months)
92	10	2023
Zero Spend 12 weeks +

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1:R165	Cell Value	contains "(blank)"	text	NO

 

[Cubist]

Try:

Book1
	E	F	G
92	10	2023	6
Sheet2

Cell Formulas
Range	Formula
G92	G92	=DATEDIF(DATE(F92,E92,1),TODAY(),"M")

 

[monkeyharris]

=DATEDIF(DATE(F92,E92,1),TODAY(),"M")

Thanks Cubist, worked perfectly. Now i'll try to understand it