Counting down the difference between two date using today function

[bamacwby]

I am trying to figure out a way to countdown the months between two dates while also using the Today function. Here is the sheet that I'm trying to use for the result to show up in cell I22. I can't figure it out, I'm at a loss. Thanks for any help.

 

[Sam_D_Ben]

they are rows 18-20

Ok, How about this,

Book1
	A	B	C	D	E	F	G	H
15	1.1	90 DAY CORROSION INSPECTION	TM 1-1520-237-23&P, WP0286	90	DAYS	28-Jul-24	29-Apr-24	8 months, 10 days ago
16	1.11	EVERY 6 MONTHS	TM 1-1520-237-23&P, WP0288	6	MONTH	30-Nov-24	31-May-24	4 months, 8 days ago
17	1.12	EVERY 12 MONTHS	TM 1-1520-237-23&P, WP0289	12	MONTH	31-Jul-23	31-Jul-22	20 months, 7 days ago
18	1.13	EVERY 24 MONTHS	H-60-20-ASAM-04, ADDENDUM PT3	24	MONTH	1-Jun-24	1-Jun-22	10 months, 6 days ago
19	1.14	EVREY 48 MONTHS	TM 1-1520-237-23&P, WP0290	48	MONTH	1-Jun-23	1-Jun-19	22 months, 6 days ago
20	1.15	PHASE MAINTENANCE INSPECTION (PMI-1 & PMI-2)	TM 1-1520-237-23&P, WP0348 0354	48	MONTH	1-Feb-26	1-Feb-22	9 months, 25 days
Sheet2

Cell Formulas
Range	Formula
H15:H20	H15	=LET(s, MIN(TODAY(), F15), e, MAX(TODAY(), F15), m, DATEDIF(s, e, "m"), d, DATEDIF(EDATE(s, m), e, "d"), m & " months, " & d & " days" & IF(F15 < TODAY(), " ago", ""))

 

[bamacwby]

Ok, How about this,

Book1
	A	B	C	D	E	F	G	H
15	1.1	90 DAY CORROSION INSPECTION	TM 1-1520-237-23&P, WP0286	90	DAYS	28-Jul-24	29-Apr-24	8 months, 10 days ago
16	1.11	EVERY 6 MONTHS	TM 1-1520-237-23&P, WP0288	6	MONTH	30-Nov-24	31-May-24	4 months, 8 days ago
17	1.12	EVERY 12 MONTHS	TM 1-1520-237-23&P, WP0289	12	MONTH	31-Jul-23	31-Jul-22	20 months, 7 days ago
18	1.13	EVERY 24 MONTHS	H-60-20-ASAM-04, ADDENDUM PT3	24	MONTH	1-Jun-24	1-Jun-22	10 months, 6 days ago
19	1.14	EVREY 48 MONTHS	TM 1-1520-237-23&P, WP0290	48	MONTH	1-Jun-23	1-Jun-19	22 months, 6 days ago
20	1.15	PHASE MAINTENANCE INSPECTION (PMI-1 & PMI-2)	TM 1-1520-237-23&P, WP0348 0354	48	MONTH	1-Feb-26	1-Feb-22	9 months, 25 days
Sheet2

Cell Formulas
Range	Formula
H15:H20	H15	=LET(s, MIN(TODAY(), F15), e, MAX(TODAY(), F15), m, DATEDIF(s, e, "m"), d, DATEDIF(EDATE(s, m), e, "d"), m & " months, " & d & " days" & IF(F15 < TODAY(), " ago", ""))

I apologize the rows that won't take the original formula that you posted are cells G16, G17, G18. and why did you put the formula in H Column

 

[Sam_D_Ben]

I apologize the rows that won't take the original formula that you posted are cells G16, G17, G18. and why did you put the formula in H Column

Please show a way to insert this formula into your image file with merged columns. Hope someone can help you. Thanks

 

[bamacwby]

Ok, How about this,

Book1
	A	B	C	D	E	F	G	H
15	1.1	90 DAY CORROSION INSPECTION	TM 1-1520-237-23&P, WP0286	90	DAYS	28-Jul-24	29-Apr-24	8 months, 10 days ago
16	1.11	EVERY 6 MONTHS	TM 1-1520-237-23&P, WP0288	6	MONTH	30-Nov-24	31-May-24	4 months, 8 days ago
17	1.12	EVERY 12 MONTHS	TM 1-1520-237-23&P, WP0289	12	MONTH	31-Jul-23	31-Jul-22	20 months, 7 days ago
18	1.13	EVERY 24 MONTHS	H-60-20-ASAM-04, ADDENDUM PT3	24	MONTH	1-Jun-24	1-Jun-22	10 months, 6 days ago
19	1.14	EVREY 48 MONTHS	TM 1-1520-237-23&P, WP0290	48	MONTH	1-Jun-23	1-Jun-19	22 months, 6 days ago
20	1.15	PHASE MAINTENANCE INSPECTION (PMI-1 & PMI-2)	TM 1-1520-237-23&P, WP0348 0354	48	MONTH	1-Feb-26	1-Feb-22	9 months, 25 days
Sheet2

Cell Formulas
Range	Formula
H15:H20	H15	=LET(s, MIN(TODAY(), F15), e, MAX(TODAY(), F15), m, DATEDIF(s, e, "m"), d, DATEDIF(EDATE(s, m), e, "d"), m & " months, " & d & " days" & IF(F15 < TODAY(), " ago", ""))

Thank you very much. This formula worked perfectly.