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!
Help Article Resources
Check out the Formula Handbook template!