Understanding Dates And Times in Microsoft Excel (Video transcript)
Excel has a great computational capability when it comes to working with dates and time. Also it has a number of built in functions that allow us to work with dates efficiently
we can enter either by slash or dash. let’s enter by slash separator. 8/1/2020. we can enter the same value with a dash separator. the result is the same.
Some country may start with Month and others may start the date.
If we mistakenly enter the dates. like this 2/30/2020. excel put as it is . that means it does not consider it as a date entry. since there is not 30 day in February.
We can also enter time. I can type 14:38
or we can make 11:30 P. It understands what we want to do.