Definition :- Excel Date Function Generate Date From The Given Year, Month, And Day In A Particular Columns. It Is Vey Much Useful When You Need To Work Dynamically Upon Changing Of Years Months And Days in Excel Worksheet.
NOTE: We should format it to date as the excel return the date in serial numbers. FORMAT: Select The Cell Or Range > Right Click > Go To Number Tab On Top Heading. Select Date Instead Of General.
EXAMPLE :- 1
![](https://excelhelp.in/wp-content/uploads/2020/12/GENERATE-DATES-BY-CONCATENATE-1024x555.png)
EXAMPLE :- 2
![](https://excelhelp.in/wp-content/uploads/2020/12/GENERATE-DATES-BY-CONCATENATE-1-1024x557.png)