Counting months between dates across multi-years

Options
Jessica Abbey
Jessica Abbey ✭✭✭

How can I calculate out how many months between 2 dates when the dates are in 2 different years?


Savings snip.JPG


Best Answer

  • Genevieve P.
    Genevieve P. Employee
    Answer βœ“

    Hi @Jessica Abbey

    I see you marked Dale's comment as not resolving your question.

    Another way to do this is to find how many days there are between the two dates, divide this by 365 (years) then multiply by 12 to find the Months.

    =ROUND((NETDAYS([Start Date]@row, [End Date]@row) / 365 * 12))

    Cheers,

    Genevieve

    Need more information? πŸ‘€ | Help and Learning Center

    こんにけは (Konnichiwa), Hallo, Hola, Bonjour, OlΓ‘, Ciao!πŸ‘‹ | Global Discussions

Answers