Add Current Date to Worksheet

First select the cell were you want to place the date. Then select the Function command under the Insert menu.

Function

 

When the Insert Function window opens, select Date & Time from the select a category drop-down menu.

Insert Function

 

From inside the list box select the Now() function, Then click on OK.

Insert Function

 

The Function Arguments dialog box will open. This function takes no arguments, so just click on OK.

Function Arguments

 

The date will appear in the selected box.

Now Function

 

back to top