Search

# Excel NOW Function | Formula Examples + FREE Video

## Excel NOW Function (Example + Video)

### When to use Excel NOWÂ Function

NOW function can be used to get the current date and time value. It is useful when you want to update the time whenever someone opens a worksheet or when a calculation is dependent on current time.

### What it Returns

It returnsÂ a serial number that represents the current date and time. The integer part of the serial number represents the date and decimal portion represents time.

=NOW()

### Input Arguments

• NOW function does not take any input arguments. It is used with empty parenthesis.
• NOW is a volatile functionÂ and shouldÂ be used with caution.
• It recalculates whenever the excel workbook is open or whenever a calculation is triggered in the worksheet. This means that the value of NOW keeps on changing based on the current date and time.
• It can be forced to recalculate by pressing the F9 key. ThisÂ recalculates the entire workbook calculations.
• To get static time (that does not recalculate), either manually type the value or use the keyboard shortcut Control + Shift + :Â (Note: this shortcut gets the time component only, and not the date).
• If you do not want the Excel NOW function to recalculate, again and again, you can change the calculations settings from automatic to manual. You can find this setting in the Excel Options.

## Excel NOW Function – Video Tutorial

Related Useful Excel Functions:

• Excel DAY Function:Â Excel DAY function can be used when you want to get the day value (ranging between 1 to 31) from a specified date. It returns a value between 0 and 31 depending on the date used as the input.
• Excel HOUR Function:Â Excel HOUR function can be used when you want to get the HOUR integer value from a specified time value. It returns a value between 0 (12:00 A.M.) and 23 (11:00 P.M.) depending on the time value used as the input.
• Excel MINUTE Function:Â Excel MINUTE function can be used when you want to get the MINUTE integer value from a specified time value. It returns a value between 0 and 59 depending on the time value used as the input.
• Excel SECOND Function:Â Excel SECOND function can be used want to get the integer value of the seconds from a specified time value. It returns a value between 0 and 59 depending on the time value used as the input.

You May Also Like the Following Excel Tutorials:

FREE EXCEL BOOK

## Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

Hello there! I'm Sumit Bansal, founder of trumpexcel.com and an Excel MVP. I started this website in 2013 with a simple goal: to share my love for Excel through easy to follow tips, tutorials and videos. I'm here to help you get the best out of MS Excel to save time and boost your productivity.

### 1 thought on “Excel NOW Function | Formula Examples + FREE Video”

1. Each time, I get to learn something new from your posts. I already knew about =Now() but didn’t know that I can use it in addition(=Now() +A2, also that I can tailor it to show AM/PM. Keep up the good work man!

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster