HOW TO GET THE NAMES OF MONTHS IN DATES WRITTEN IN CAPITAL LETTERS, BOTH IN ENGLISH AND SPANISH

JRHPERU Please do not write in all capital letters, it is harder to read and sometimes considered as shouting.

Have a look at the attached workbook, it contains a small table with three columns. The first are just fixed dates, the second and thirs use a formula to display the names of the months. Then there is a second table with just one row in which I demonstrate how to use the data of the first table.