count number of months between today and a cell value?

[BigPapaMurf]

On one sheet, I've got a table with multiple rows/columns, one of the columns includes cell values that may be blank or include a future date (mm/dd/yyyy).

I've got another sheet that asks how many months before i reach that date. What would be the formula best suited for this task?

Note, after figuring out this formula, I'll be applying a vlookup so that the row of my choice shows up on that one cell. Not relevant to what I'm asking help for.

Sample attached

Thanks,
Murphy

Edited the sample for better understanding / showing i know how to use data validate / vlookup

[Bo_Ry]

Maybe try
Months from today till that date.

=DATEDIF(TODAY(),VLOOKUP($E$8,Sheet1!$I$6:$N$20,6,0),"m")

or
=INT(YEARFRAC(TODAY(),VLOOKUP($E$8,Sheet1!$I$6:$N$20,6,0))*12)

[Phuocam]

Try this:

=IFERROR(DATEDIF(TODAY(),VLOOKUP($E$8,Sheet1!$I$6:$N$20,6,0),"m"),"")

[BigPapaMurf]

Maybe try
Months from today till that date.

=DATEDIF(TODAY(),VLOOKUP($E$8,Sheet1!$I$6:$N$20,6,0),"m")

or
=INT(YEARFRAC(TODAY(),VLOOKUP($E$8,Sheet1!$I$6:$N$20,6,0))*12)

Try this:

=IFERROR(DATEDIF(TODAY(),VLOOKUP($E$8,Sheet1!$I$6:$N$20,6,0),"m"),"")

Those all work. Thanks!!