The NOW Function in Excel returns the current date and time. This returned date and time updates as a spreadsheet is opened or modified.


  =NOW ()  

Like the TODAY Function, the NOW Function takes no arguments. You can also add and subtract from the returned date.

Pressing F9 will force a spreadsheet to recalculate.

NOW Function Usage Example:

Review the example below. ­

NOW Function

Leave a Reply

AverageIFS Function

Finding the arithmetic mean in Excel is very easy.  In this example, we will be using the AVERAGEIFS function. We

Read More »

VBA ColorIndex

Colors Colors could be very important and useful in excel application. There are two ways in which you can get

Read More »


The NETWORKDAYS function in Excel allows you to return the number of workdays between two specified dates. This function automatically

Read More »
Scroll to Top