How to join date from three column to one column
Join this channel to get access to perks:
https://www.youtube.com/channel/UC3XH...
#ExcelForBeginners #ExcelTipsAndTricks #ExcelTutorials2020
Hello my friend today I going to show you How to join date from three column to one column, If you not understand or need more video please drop comment below, I'll make the video for you. I hope my video tutorials is can help you, Please like and subscribe to get new video. Thank you for watching.
This is introduction : How to join date from three column to one column
I think you maybe boring with data-entry typing with wrong date format in one column. So the solution, let's them typing date in three column (Day column, Month Column, Year column) after that you can join this column to one column with format as you wanted.
1- Using this formula =Date(Year,Month,Day)
.Year (Click on year cell)
. Month ( Click on Month cell)
.Day (Click on Day cell)
2- Press Enter
3- Done.
For more information about technology, software download, computer tip, game, video tutorial and Hollywood movies. Please go to my blog : https://bigboxsoftware.blogspot.com/ or https://bigboxsoftware.net/
Check out my previous video :
- How to make freeze columns or rows | Excel Tips and Tricks #13 : https://youtu.be/SKcKr5nr2kA
- How to Join and Separate text in difference column | Excel Tips and Tricks #12 : https://youtu.be/g-IukC3pF-0
- How to Highlight Auto the Active Row and Column in a Data Range | Excel Tips and Tricks #11: https://youtu.be/KPkYWsNnznM
- How to create Bar Code in excel | Excel Tips and Tricks #10 : https://youtu.be/zQgq0PJKHtA
- How to turn off Protected View in Excel | Excel Tips and Tricks #09 : https://youtu.be/qXcPM7j51Tw
- How to insert pages number in excel | Excel Tips and Tricks #08 : https://youtu.be/WWtjeiL51NQ
Check out my popular playlist :
- Excel tutorials 2020 : https://www.youtube.com/playlist?list...
- Blogger tips and tricks : https://www.youtube.com/playlist?list...
- Google Form : https://www.youtube.com/playlist?list...
- General Knowledge: https://www.youtube.com/playlist?list...
- Technology tips and tricks: https://www.youtube.com/playlist?list...
- Game : https://www.youtube.com/playlist?list...
Computer tips and tricks : https://www.youtube.com/playlist?list...
If you would like to know something about computer tips track, Please drop comment below I will make video to reply you. Also do not forget to subscribe my channel to get new tips about computer, mac, phone, game, app … My channel is creating video refer to technology and video tutorial about computer for you upper 2 video a week.
Thank you for your time, And hope all my video is helpful for you, Have a nice day !