Count Number of Months

Options
✭✭✭✭

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

• ✭✭✭✭✭✭
Options

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

`=13 - MONTH(Date@row)`

Let me know if that works for you!

Amber Eakin, MSLS, M.Ed.

Adult Education Specialist | Process Improvement Enthusiast

• ✭✭✭✭✭✭
Options

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

`=13 - MONTH(Date@row)`

Let me know if that works for you!

Amber Eakin, MSLS, M.Ed.

Adult Education Specialist | Process Improvement Enthusiast

• ✭✭✭✭
Options

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

• ✭✭✭✭✭✭
Options

My pleasure!

Amber Eakin, MSLS, M.Ed.

Adult Education Specialist | Process Improvement Enthusiast

• ✭✭✭✭
Options

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

• ✭✭✭✭✭✭
Options

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))`

Amber Eakin, MSLS, M.Ed.

Adult Education Specialist | Process Improvement Enthusiast

• ✭✭✭✭
Options

Yep...functioning as designed 😀 great!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!