A measured NOW gallery: the date/time serial, its relationship to TODAY, the time fraction and volatility — every assertion engine-verified. Live, free.
Zero arguments. Returns a volatile date+time serial number. INT(NOW())=TODAY(); NOW()-TODAY() is the time fraction.
NOW() returns the current date and time as a serial number; TODAY() returns just the date (midnight). The integer part of NOW equals TODAY, and the fractional part is the time of day. NOW is volatile — it recalculates on every edit. The gallery uses date-stable assertions (booleans and the year) plus snapshot readings, all measured live. Click any row.
| Expression | Result | Why |
|---|---|---|
| =ISNUMBER(NOW()) | TRUE | NOW is a number |
| =INT(NOW())=TODAY() | TRUE | Date part equals TODAY |
| =NOW()>=TODAY() | TRUE | At or after midnight |
| =NOW()-TODAY()<1 | TRUE | Fraction is time of day |
| =YEAR(NOW()) | 2026 | Current year |
| =NOW()>DATE(2026,1,1) | TRUE | After 1 Jan 2026 |
| =TEXT(NOW(),"yyyy") | 2026 | Year as text |
| =SECOND(NOW())>=0 | TRUE | Seconds are valid |
| Expression | Result | Why |
|---|---|---|
| =ISNUMBER(NOW()) | TRUE | NOW is a serial number, not text |
| =INT(NOW())=TODAY() | TRUE | The date part equals TODAY |
| =NOW()-TODAY() | 0..1 | The fractional part is the time of day (0.5 = noon) |
| =YEAR(NOW()) | 2026 | The current year (stable within the year) |
| =NOW()=TODAY() | FALSE | Almost never equal — NOW carries a time fraction |
Booleans and YEAR are date-stable; MONTH/DAY presets are build-date snapshots that advance with the clock.
10 failure patterns mined from actual user reports on Reddit, Stack Overflow and Super User — each with the authentic symptom, root cause, a fix, and a runnable formula. Not textbook theory.
NOW and TODAY are universal, zero-argument volatile functions across all Excel versions, Google Sheets and LibreOffice. Both use the local system clock.
| Platform | Support | Notes | Gotcha |
|---|
NOW is one piece. The full course walks the toolkit end to end with live, measured examples.