How To Join The Date, Month And Year To Give Various Date Formats In Excel - Using TEXTJOIN And TEXT
We cover how to join cells containing the day, month and year together to give different date formats using the TEXTJOIN and TEXT functions. We firstly show how to use the TEXTJOIN function to apply the DD/MM/YYYY and MM.DD.YYYY formats and then used the TEXT function to give the month in text format.
Get The Day, Month & Year From A Date In Excel:
• Get The Day, Month & Year From A Date...
Subscribe for weekly Excel tutorials, techniques and examples:
/ @theexcelhub
Please share this video with others that may find it useful:
• How To Join The Date, Month And Year ...
Please comment below if you have any feedback or any suggestions for videos you would like us to upload next!
🌍 The Excel Hub website: https://theexcelhub.com/
📸 Instagram: / theexcelhub
ABOUT US:
The Excel Hub seeks to enhance your Excel and VBA knowledge by providing value-adding tutorials, techniques and examples in order to help you take your spreadsheet and data analysis skills to the next level.
For any enquiries, please contact:
[email protected]
Overview: (0:00)
Forward Slash Delimiter: (0:36)
Full Stop Delimiter: (1:13)
Text Format: (1:34)