Returns the current date and time in datetime format.
The NOW function is useful when you need to display the current date and time on a worksheet or calculate a value based on the current date and time, and have that value updated each time you open the worksheet.
A date (datetime).
The result of the NOW function changes only when the column that contains the formula is refreshed. It is not updated continuously.
The TODAY function returns the same date but is not precise with regard to time; the time returned is always 12:00:00 AM and only the date is updated.
The following example returns the current date and time plus 3.5 days: