Question

how do you enter data and time in an excel sheet
​

Answer 1

Explanation:

Insert a static date or time into an Excel cell

On a worksheet, select the cell into which you want to insert the current date or time.

Do one of the following: To insert the current date, press Ctrl+; (semi-colon). To insert the current time, press + ; (semi-colon).

Answer 2

Answer:

I hope it is helpful to all

Explanation:

A timestamp is something you use when you want to track activities.

For example, you may want to track activities such as when was a particular expense incurred, what time did the sale invoice was created, when was the data entry done in a cell, when was the report last updated, etc.

Keyboard Shortcut to Insert Date and Timestamp in Excel

Using TODAY and NOW Functions to Insert Date and Timestamps in Excel

Insert Current Date Using TODAY Function

Insert Date and Timestamp Using NOW Function

Circular References Trick to Automatically Insert Date and Timestamp in Excel

Using VBA to Automatically Insert Timestamp in Excel

Creating a Custom Function to Insert Timestamp