Date and Time functions in Excel || Ms Excel
To enter a date in Excel, use the "/" or "-" characters. To enter a time, use the ":" (colon). You can also enter a date and a time in one single cell.
Dates are in US Format(type of format depends on your windows regional settings).
Watch the video to learn how to use these functions
For more information : https://support.microsoft.com/en-us/o...