Syntax
=NOW()Arguments
NOW takes no arguments. Type =NOW() with empty parentheses.
How to use NOW
NOW is volatile: it recalculates every time the workbook changes, so its result can differ each time.
NOW takes no required arguments. Type =NOW( in a cell and SheetsBat shows the arguments as you go. Optional arguments are shown in square brackets; leave them out to use their default.
Related date and time functions
- MINUTEReturns the minute (0 to 59) of a time.
- MONTHReturns the month (1 to 12) of a date.
- NETWORKDAYSCounts the working days (Monday to Friday) between two dates, both included, leaving out holidays.
- NETWORKDAYS.INTLCounts the working days between two dates, both included, with a choice of weekend days and holidays.
- SECONDReturns the second (0 to 59) of a time.
- TIMEBuilds a time of day from hours, minutes and seconds.
- TIMEVALUEConverts a time written as text into a fraction of a day.
- TODAYReturns the current date.
- WEEKDAYReturns the day of the week of a date as a number (by default 1 for Sunday to 7 for Saturday).