Forum Discussion
Months remaining
Good morning, I'm currently having an issue getting a formula to work. currently column i contains expirations formatted as MMM-YYYY. I need column J to show either months remaining as a positive o...
Shouldn't 12 in your formula be cell reference I3?
Does this do what you want?
=IF(OR(I3={"", "N/A"}), "", IF(TODAY()>=I3, -DATEDIF(EOMONTH(I3, -1)+1, TODAY(), "m"), DATEDIF(TODAY(), EOMONTH(I3, 0), "m")))