Is it possible to create a single macro that auto capitalizes the months of the year (e.g., "july" > "July") and the days of the week, rather than creating a macro for each month and day?
Yeah, A million ways to do that. The filter Action does that. Post your Macro and explain more if the filter action doesnt solve it