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

Published: 02 May 2024
on channel: 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

Watch video Learn How to Extract days, Months and Years from Given Dates in Excel online, duration hours minute second in high quality that is uploaded to the channel Sophia Inspizone Training 02 May 2024. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 13 times and liked it 0 visitors.