Examples for the excel now formula
Copy these examples into a spreadsheet and adjust the ranges for your own data.
NOW syntax pattern
=NOW()Use this NOW pattern as the starting point for your spreadsheet formula.
NOW in a worksheet
=NOW()Returns the current local date and time.
When to use NOW
Use NOW when you need to return the current local date and time.
- Construct dates, times, and durations.
- Extract time parts and shift dates for reporting.
How NOW works in Quadratic
In Quadratic, NOW follows the syntax NOW(). The function works inside Quadratic formulas and can be combined with spreadsheet ranges, tables, and other formulas.
Common NOW mistakes
Most NOW issues come from mismatched argument types, ranges that do not cover the intended data, or optional parameters being omitted when the default behavior is not what you expected.
- Check each required parameter before copying the formula across a sheet.
- Confirm that ranges line up with the rows or columns you intend to analyze.
- Use Quadratic AI to explain or debug the formula when the result looks wrong.