Learn How to Extract days, Months and Years from Given Dates in Excel

Опубликовано: 02 Май 2024
на канале: Sophia Inspizone Training

📅 Unlock the power of date extraction with our latest tutorial! Follow these simple steps to effortlessly extract days, months, and years from your given dates:

1. Select all dates and fill them into the right columns.
2. Drag the cell bar to apply values across all cells.
3. Select the days column and press Control + 1.
4. In custom, remove 'General' and enter 'DDDD' for Days, then click OK.
5. Witness all days extracted for your dates.
6. Repeat the process for Months and Years:
Select Months column, press Control + 1, and enter 'MMMM'.
Select Years column, press Control + 1, and enter 'YYYY'.

https://www.inspizone.com/

Now revel in the magic as all days, months, and years are effortlessly extracted! Don't forget to like the video and follow our channel for more helpful tutorials. Subscribe now for regular updates!

#DateExtraction #ExcelTips #exeltricks #inspizonetraining #exceltraining

Смотрите видео Learn How to Extract days, Months and Years from Given Dates in Excel онлайн, длительностью часов минут секунд в хорошем качестве, которое загружено на канал Sophia Inspizone Training 02 Май 2024. Делитесь ссылкой на видео в социальных сетях, чтобы ваши подписчики и друзья так же посмотрели это видео. Данный видеоклип посмотрели 13 раз и оно понравилось 0 посетителям.