Count Number of Months


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

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!