📅 ¿Quieres saber cómo convertir una fecha en día de la semana en Excel usando solo la función TEXTO? En este vídeo descubrirás paso a paso cómo obtener el día de la semana a partir de cualquier fecha, verás cómo personalizar el formato para mostrar el nombre del día y aprenderás a automatizar tus datos en Excel de forma sencilla. ¡No te lo pierdas y saca el máximo partido a tus hojas de cálculo!
00:00They give you the list of holidays for the next year in this Excel format, and since you love a party, you go running to the calendar to see what day it falls on, leave the calendar alone and I'll show you how to see it in Excel.
00:11In column A the holidays and in column B the day it falls on, we write the same text.
00:18The value is this cell, write a semicolon, and the format is the following, open the quotes and write 4D.
00:25Close the quotes, close the parentheses, press enter and here we have the day, double click on the cell to drag it, the rest, and this is the deal, 2 Sundays and 2 Saturdays, well, not so bad, Sundays can move to Monday, if not, well, it depends on your community, and here comes a little something that will say, oh, but I only want to see 2 letters, well, then edit the formula.
00:48Let's remove a D, press enter, drag it to the rest and here you have the abbreviation of the day.
00:52What happens if I leave only 1D or 2?
00:56Well, you'll figure that out for yourself, if you want to master computer applications, subscribe to my email list, I'll leave the link in the video description, where I share things that I don't share anywhere else.
01:07Like it if you found it helpful and I'll see you in the next video.
