Enter Date & Time in Excel Worksheets

Enter & Date and Time Data Video

Many Excel worksheets use dates either as part of the sheet data or for use in calculations, such as the number of days an invoice is overdue. Excel worksheets also often use times, such as recording when a transaction took place or calculating the total number of hours an employee has worked in a given period. For these and similar uses, you need to know how to enter date and time values into a cell