Are you an Excel user who needs to keep track of important dates?

Are you looking for a more efficient way to insert todays date into your Excel spreadsheets?

If so, youre in luck.

Article image

Valeriy Odintsov / Tab-TV

it’s possible for you to choose a static or dynamic date value depending on your needs.

In other words, whether the date will be updated or not.

So heres how it works.

Article image

However, adding todays date using the shortcut is even faster.

The syntax for the function is simple: =TODAY().

Theres also the NOW() function.

Article image

It inserts both the current date and time into an Excel spreadsheet.

This works similarly to the TODAY() function.

It updates automatically every time you launch the Excel file.

Article image

To create a macro, follow these instructions:

This macro will insert todays date in the active cell.

Article image

Article image

Article image

Article image

Article image

Article image

Article image

Article image

Article image