How to Insert Date in Excel

Here is a very simple yet effective way to insert or add date in excel. To do so, you only need to type one of these function in a cell:

=now()           to insert current date and time
=today()        to insert current date only

FYI, with the two formulas above, it will add current date same with your computer date and clock. Make sure to synchronize your computer date and time first. If you use formula above and save your documents, you'll find the date and time changes by date of your computer. So if you open the document tomorrow, the function will show date of tomorrow. To avoid changing date made by both formula, copy and paste values it in same cell. You can also change the date format from menu Format - Cells... or press Ctrl + 1