NOW function in MS-Excel

The current Date and Time
5/22/2014 21:18	=NOW()
41781.88886	=NOW()

What Does It Do?
This function shows the current date and time. The result will be updated each time the worksheet is opened and every time an entry is made anywhere on the worksheet.

Syntax
=NOW()

Formatting
The result will be shown as a date and time. If it is formatted to show as a number the integer part is used for the date and the decimal portion represent the time.