The Excel NOW function is unusual in that it doesn't have any arguments. It simply returns the current date and time from your computer clock.
Caution: The NOW function is volatile, meaning it recalculates every time virtually anything changes in your workbook...best use it sparingly!
Syntax: = NOW()
Tip: When you enter the NOW function Excel will format the cell in the date - time format based on your regional settings, (where no prior formatting was applied to the cell).
Excel NOW Function Examples
Use the NOW function to calculate the difference between a date-time serial number and now. e.g. how many hours since x or what will the time be in x hours.
Note: My dates are dd/mm/yyyy
|Excel TODAY Function||Returns today's date|
Similar to the NOW function, the TODAY function returns the current date serial number from your computer clock.
Free eBook - Working with Date & Time in Excel
Everything you need to know about Date and Time in Excel, including all Date functions explained with examples - Download the free eBook and Excel file with detailed instructions.