Jul 23 2019 12:36 AM
HOW TO GET THE NAMES OF MONTHS IN DATES WRITTEN IN CAPITAL LETTERS, BOTH IN ENGLISH AND SPANISH
Jul 23 2019 12:58 AM
@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.
Jul 23 2019 07:06 AM
Jul 23 2019 01:52 PM
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.