Functions / Date and time NOW Copy page Copy as markdownThe page as text, ready for a chat View as markdown/docs/functions/now.md Ask Claude about this pageOpens Claude with this page's address Returns current date and time. Excel: Not checked yetGoogle Sheets: Not checked yetReturns: Number (date-time serial) Volatile: recomputes on every evaluation Examples =NOW() Syntax NOW() Related DATECreates date from year, month, day. DATEDIFCalculates difference between two dates. DATEVALUEConverts date text to serial number. DAYReturns day of month from date. DAYSReturns number of days between two dates. DAYS360Returns days between dates on 360-day year.
