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

JRHPERU 

If to show the date using format with capital letter in the same cell in which the date is entered (e.g. some invoices or reports where capital letter format is required) when, to my knowledge, that's only with macro. You may easy google for such samples.

If the date and its text representation are in different cells - with formulas as above it'll be easier.

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.