How do you enter a date in MS Excel?

Answer 1

You can use almost any format you like to enter the date. The key to using and viewing dates is the cell format. Right-click on the cel and select cell format. Then you can format the date to look almost any way you like.

Answer 2

You can type the date in and the time in, using slashes to separate the dates and colons to separate the time, like this:

02/05/87

12:15

Using the Ctrl - ; combination, you can put in the current date. Using Ctrl - : you can put in the current time.

You can use the DATE function to construct a date with the year, month and day elements and the TIME function from the different hour, minute and second elements:

=DATE(1938,12,5)

=TIME(3,15,28)

Answer 3

Use the built in Help (F1 key) ask the question there!