Is there a formula to change a number to a month? Or calculate number of days in a month from a #?

My ultimate goal is to get the Month Start and Month End for any given month so I can then calculate the # of Days in a Month.

The # of Days each month is what I need for my process.

Currently, I have the below setup to work with some other formulas I have going on. The month is displayed as a number that I manually change each month. So "4" is April.

If there is a shortcut to get the number of days in the month of April that would be excellent.

If not, then is there a way, in the cell below "4", I can change it say April? And then, is there a formula I can use to determine the first day of April, then the last day of April, then I can subtract those two?

Any help is appreciated!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!