Learn How to Extract days, Months and Years from Given Dates in Excel
📅 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