Home>
= text (today ()-B2, "yy year mm month")

The answer for +1 month comes out with this formula, but the exact answer
I don't know the formula (example: January to March is the second month).

I understand that mm-1 can be done, but to put it in the above formula,
What is the best formula?

Please teach me.

  • Answer # 1

    Maybe this ...

    = IF (DATEDIF (B2, today (), "Y")>0, DATEDIF (B2, today (), "Y")&"year", "")&DATEDIF ( B2, today (), "YM")&"Month"