On UrbanPro

View My Profile       Proud to be a Teacher       Write a Review  

Thursday, May 22, 2014

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.

No comments:

Post a Comment

Popular Posts