Count Number of Months

John Littler

Hello, I am looking to count the number of months remaining in a calendar year without having to change my formula monthly, simply put if the date is 9/15/23 I'd like the output to be "4", if 12/20/23 = "1" etc.

@Paul Newcome

Amber Eakin

@John Littler - Good morning! Give this a try.

=13 - MONTH(Date@row)

Let me know if that works for you!

Amber Eakin

@John Littler - Good morning! Give this a try.

=13 - MONTH(Date@row)

Let me know if that works for you!

John Littler

@Amber Eakin perfect! Works as expected...thank you!

Amber Eakin

My pleasure!

John Littler

Hi Amber, 1 wrinkle...I have records that are in 2024. Do you suggest adding an iferror statement for the year?

Amber Eakin

Hi John - This formula will give you a number if it's the current year. If it's in the past, it'll be blank; if it's in the future, it'll be blank. Will that work for your use case?

=IF(YEAR(Date@row) = YEAR(TODAY()), 13 - MONTH(Date@row))

John Littler

Yep...functioning as designed 😀 great!