I went through and tried all the formulas. The one for the last day of the month works well except if the previous month was February. But I also ran into another weird issue. The following formula did not work for me and I can't figure out why:
=Format(Today,"M")
Returned:
March 05
From everything I've researched it should return the month digit. Does anyone have any ideas on why I get todays date instead with month and day.