Separating Date Day Month Year

An Excel file that teaches how to perform Historical Day Month Year Separation operation.

Excel Separating Date Day Month Year

DAY, MONTH and YEAR functions are used. Three components are extracted from a single date field. Fields are used for sorting and reporting. Practice is demonstrated with sample tables. The solution simplifies historical analysis.

Hope it is useful.