Compatibilidad: 
En muchas ocasiones necesitamos escribir en las fechas los meses en mayúscula en las celdas Excel.
MES: FORMATO LARGO
| A | B | C | |
|---|---|---|---|
| 1 | Fecha | Fórmula | Mostrado como |
| 2 | 15/01/2020 | =MAYUSC(TEXTO(A1;"mmmm")) | ENERO |
| 3 | 15/01/2020 | =MAYUSC(TEXTO(A2;"dd/mmmm/aaaa")) | 15/ENERO/2020 |
| 4 | 15/01/2020 | =MAYUSC(TEXTO(A3;"dd mmmm aaaa")) | 15 ENERO 2020 |
| 5 | 15/01/2020 | =MAYUSC(TEXTO(A4;"dd-mmmm-aaaa")) | 15-ENERO-2020 |
| 6 | 15/01/2020 | =MAYUSC(TEXTO(A5;"ddmmmmaaaa")) | 15ENERO2020 |
| 7 | 15/01/2020 | =MAYUSC(TEXTO(A6;"mmmm / aaaa")) | ENERO / 2020 |
| 8 | 15/01/2020 | =MAYUSC(TEXTO(A7;"mmmm aaaa")) | ENERO 2020 |
| 9 | 15/01/2020 | =MAYUSC(TEXTO(A8;"mmmm - aaaa")) | ENERO - 2020 |
| 10 | 15/01/2020 | =MAYUSC(TEXTO(A9;"aaaa / mmmm")) | 2020 / ENERO |
| 11 | 15/01/2020 | =MAYUSC(TEXTO(A10;"aaaa mmmm")) | 2020 ENERO |
| 12 | 15/01/2020 | =MAYUSC(TEXTO(A11;"aaaa - mmmm")) | 2020 - ENERO |
| 13 | 15/01/2020 | =MAYUSC(TEXTO(A12;"dd/mmmm")) | 15/ENERO |
| 14 | 15/01/2020 | =MAYUSC(TEXTO(A13;"dd mmmm")) | 15 ENERO |
| 15 | 15/01/2020 | =MAYUSC(TEXTO(A14;"dd-mmmm")) | 15-ENERO |
| 16 | 15/01/2020 | =MAYUSC(TEXTO(A15;"dddd dd mmmm aaaa")) | MIÉRCOLES 15 ENERO 2020 |
| 17 | 15/01/2020 | =MAYUSC(TEXTO(A16;"dddd, dd \d\e mmmm aaaa")) | MIÉRCOLES, 15 DE ENERO 2020 |
| 18 | 15/01/2020 | =MAYUSC(TEXTO(A17;"dddd dd \d\e mmmm aaaa")) | MIÉRCOLES 15 DE ENERO 2020 |
| 19 | 15/01/2020 | =MAYUSC(TEXTO(A18;"dddd, dd \d\e mmmm aaaa")) | MIÉRCOLES, 15 DE ENERO 2020 |
| 20 | 15/01/2020 | =TEXTO(A19;"dddd")&", " &MAYUSC(TEXTO(A19;"dd \d\e mmmm aaaa")) | miércoles, 15 DE ENERO 2020 |
| 21 | 15/01/2020 | =NOMPROPIO(TEXTO(A20;"dddd"))&", " &MAYUSC(TEXTO(A20;"dd"))&" de "&MAYUSC(TEXTO(A20;"mmmm aaaa")) | Miércoles, 15 de ENERO 2020 |
| 22 | 15/01/2020 | ="Mes: "&MAYUSC(TEXTO(A21;"mmmm")) | Mes: ENERO |
MES: FORMATO CORTO
| A | B | C | |
|---|---|---|---|
| 1 | Fecha | Fórmula | Mostrado como |
| 2 | 15/01/2020 | =MAYUSC(TEXTO(A1;"mmm")) | ENE |
| 3 | 15/01/2020 | =MAYUSC(TEXTO(A2;"dd/mmm/aaaa")) | 15/ENE/2020 |
| 4 | 15/01/2020 | =MAYUSC(TEXTO(A3;"dd mmm aaaa")) | 15 ENE 2020 |
| 5 | 15/01/2020 | =MAYUSC(TEXTO(A4;"dd-mmm-aaaa")) | 15-ENE-2020 |
| 6 | 15/01/2020 | =MAYUSC(TEXTO(A5;"ddmmmaaaa")) | 15ENE2020 |
| 7 | 15/01/2020 | =MAYUSC(TEXTO(A6;"mmm / aaaa")) | ENE / 2020 |
| 8 | 15/01/2020 | =MAYUSC(TEXTO(A7;"mmm aaaa")) | ENE 2020 |
| 9 | 15/01/2020 | =MAYUSC(TEXTO(A8;"mmm - aaaa")) | ENE - 2020 |
| 10 | 15/01/2020 | =MAYUSC(TEXTO(A9;"aaaa / mmm")) | 2020 / ENE |
| 11 | 15/01/2020 | =MAYUSC(TEXTO(A10;"aaaa mmm")) | 2020 ENE |
| 12 | 15/01/2020 | =MAYUSC(TEXTO(A11;"aaaa - mmm")) | 2020 - ENE |
| 13 | 15/01/2020 | =MAYUSC(TEXTO(A12;"dd/mmm")) | 15/ENE |
| 14 | 15/01/2020 | =MAYUSC(TEXTO(A13;"dd mmm")) | 15 ENE |
| 15 | 15/01/2020 | =MAYUSC(TEXTO(A14;"dd-mmm")) | 15-ENE |
| 16 | 15/01/2020 | =MAYUSC(TEXTO(A15;"dddd dd mmm aaaa")) | MIÉRCOLES 15 ENE 2020 |
| 17 | 15/01/2020 | =MAYUSC(TEXTO(A16;"dddd, dd \d\e mmm aaaa")) | MIÉRCOLES, 15 DE ENE 2020 |
| 18 | 15/01/2020 | =MAYUSC(TEXTO(A17;"dddd dd \d\e mmm aaaa")) | MIÉRCOLES 15 DE ENE 2020 |
| 19 | 15/01/2020 | =MAYUSC(TEXTO(A18;"dddd, dd \d\e mmm aaaa")) | MIÉRCOLES, 15 DE ENE 2020 |
| 20 | 15/01/2020 | =TEXTO(A19;"dddd")&", " &MAYUSC(TEXTO(A19;"dd \d\e mmm aaaa")) | miércoles, 15 DE ENE 2020 |
| 21 | 15/01/2020 | =NOMPROPIO(TEXTO(A20;"dddd"))&", " &MAYUSC(TEXTO(A20;"dd"))&" de "&MAYUSC(TEXTO(A20;"mmm aaaa")) | Miércoles, 15 de ENE 2020 |
| 22 | 15/01/2020 | ="Mes: "&MAYUSC(TEXTO(A21;"mmm")) | Mes: ENE |
Nivel de dificultad: 
Excel Básico
Excel Básico- Consultar:
Es excelente para ampliar màs nuestro conocimiento en Excel.