Whenever you use Date inside the Concatenate function in Excel, the date displays as a number. Using the Text function inside Concatenate let's you format and display the date the way you want it to be.
________________
SUBSCRIBE NOW!
/ @excelrush
Click this link to learn the most essentials of Excel
• A Drop of Excel - Learn the most esse...
Click this link to learn more awesome functions in Excel
• Learn Excel's Tricks