40. How to Split Date and Convert to Date Format in Excel Khmer

Split Date and Convert to Date Format in Excel

(បំបែកថ្ងៃខែឆ្នាំ និង តភ្ជាប់ជា Date វិញ) -

In this Excel tips tutorial, you will learn how to split date into normal number values such as Day, Month, and Year in Microsoft Excel step by step. After that, this video also show you how to convert those number values back into correct date format with help of the DATE formula in Excel. This tutorial is very useful for beginners, office work, and data cleaning task in Excel.
Refer to video for more detail and easy understanding.

DATE Formula: Convert number input into Date format

=DATE(Year, Month, Day)
◾ Year: Required, number of year.
◾ Month: Required, number of month.
◾ Day: Required, number of day.

Download Example Excel File below
Download Souce 1
Download Souce 2

Go To Next Video Below

Join My Special Courses To Level Up Your Skills: 👉 UP SKILLS 👈

Useful Links

⚡Learn Code Khmer (HTML, CSS, JavaScript, ReactJS, PHP,...)
⚡Free Download Khmer Books PDF
⚡Telegram: ReanComputer101