← Back to level 1
Level 1Next
NOW
A easy date formula for deadlines, schedules, and reporting timelines.
Syntax
=NOW(...)Step-by-step explanation
- 1Use a date or time formula when the result should update automatically.
- 2Place the function in the cell where you need a live date or time value.
- 3Format the cell if needed so the output is easy to read.
Common mistakes
Expecting the value to stay fixed forever
Using the wrong cell format
Forgetting that time-sensitive formulas recalculate
Example table
A quick scenario to connect the syntax to the result.
| 12 | 18 |
| 8 | 42 |
Formula
=NOW(A1:B2)
Result
42
Worked example
- 1This formula has no input table because it pulls the current date or time directly.
- 2Type =NOW(A1:B2) in the cell where you want a live timestamp.
- 3Excel will show 42 or a current equivalent when recalculated.
Practice area
Use NOW to work with a date field from a workbook used by students or office staff.
Match against the syntax block above.