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

How to Split Date and Convert to Date Format in Excel Khmer
(បំបែកថ្ងៃខែឆ្នាំ និង តភ្ជាប់ជា Date វិញ) - In this Excel tips show how to split date into number as Day, Month and Year in normal value. Then show you how to convert that numbers into date format with help of DATE formula.

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 Full PDF and Excel Example Files: Click Here
Register My Special Course: វគ្គ ១០១ រូបមន្ត Excel

Download Example Excel File below
Download Souce 1
Download Souce 2