Ravindra BagaleCourses & study guides Track your progress

Excel NOW Function

By · Last updated:

Chala mitrano — today NOW. Live date and time together. Great for ticket stamps; freeze it when you archive.

Fictional sample data for learning. Support ticket timestamps (Aurangabad BPO + Austin). Mixed ₹ and $. Fictional tickets.

Purpose

Return the current date and time. Updates on recalculation — use for timestamps.

Return value

A date-time serial for now.

Syntax

NOW()

Arguments

ArgumentRequired?Description
(none)—NOW takes no arguments.

Version

All Excel versions. LibreOffice Calc and Google Sheets too.

How to use — Why → What → How

Why: Ticket sheets need open time, not just the day. NOW stamps both. Support desks in Aurangabad and Austin stamp ticket open time with NOW. In Indian back offices and foreign sister teams, NOW shows up on leave, SLA and invoice sheets every week.

What: NOW() returns current date and time. Format as Custom dd-mmm-yyyy hh:mm. Read every argument in the table once before you type; each one changes the answer on purpose.

How — numbered steps:

  1. Type =NOW() in the stamp cell.
  2. Format to show date and time.
  3. For archives, Paste Values so the stamp freezes.
  4. Do not use NOW inside a column you fill once and expect to stay fixed without Paste Values.
  5. Paste Values only when you truly need a frozen snapshot — not for live ageing.

Ravindra Bagale's Tip

Friends, after you learn NOW, open a real leave or invoice sheet and find one cell this function would fix this week.

Ravindra Bagale's Tip

Friends, sleep on NOW and rebuild example 1 tomorrow without looking.

Ravindra Bagale's Tip

Friends, say the business question in plain words before you type =NOW.

Ravindra Bagale's Tip

Friends, after you finish NOW, open yesterday’s real workbook and find one place this function would have saved ten minutes. That habit turns lessons into salary skills.

Ravindra Bagale's Tip

Friends, treat NOW like a seatbelt on date sheets — use it before a manager asks why the deadline slipped.

Download practice file: practice-now.xlsx (includes sheet About this data, practice sheets, and Answers).

Worked examples

1) Live stamp

Aurangabad ticket header.

FieldValue
Opened(formula)
Formula: =NOW()

Result: (live date-time)

What it means: Updates when Excel calculates.

2) Readable label

Austin dashboard.

Label
Last refresh
Formula: =TEXT(NOW(),"dd-mmm-yyyy hh:mm")

Result: (formatted now)

What it means: TEXT makes a stable-looking label string.

3) TODAY vs NOW

Compare on one row.

FnShows
TODAYdate
NOWdate+time
Formula: =NOW()-TODAY()

Result: (fraction of day = time portion)

What it means: The decimal part of NOW is the time.

4) Freeze archive

Close ticket #A-104.

Ticket₹ fee
A-104250
Formula: Paste Values over NOW()

Result: fixed stamp

What it means: Closed tickets must not keep moving.

5) Same-day duration idea

Start typed; end = NOW.

StartEnd
2026-10-31 09:00(NOW)
Formula: =NOW()-A2

Result: (elapsed day fraction)

What it means: Format as [h]:mm for hours open.

6) Date-only from NOW

Need date part only.

Stamp
(NOW)
Formula: =INT(NOW())

Result: (date serial)

What it means: INT drops the time; or just use TODAY().

About this data. Small demo rows for learning. Real sheets are longer; the same formula pattern scales when columns are clean.

Common errors and fixes

Keeps changing — Expected freeze. Fix: Paste Values.
Ugly decimal — Wrong format. Fix: Custom date-time.
Timezone surprise — Laptop TZ differs. Fix: Agree on IST for the team.

Notes and tips

  • Revisit the NOW errors table after the quiz — most classroom mistakes are listed there.
  • Build one brand-new example on a blank sheet from memory before you close the laptop.
  • If a result looks wrong, check date formats and regional settings before changing the formula.
  • Share one tip from this page with a classmate in Marathi or Hindi — teaching locks the idea.
  • Keep currency symbols consistent inside a single report column even when practice mixes ₹ $ £ € across examples.
  • When Excel versions differ at home and in class, write the fallback under the modern formula in a comment.
  • Drill: log three ticket rows with NOW and convert one to Paste Values for an archive.
  • NOW vs TODAY: NOW has date+time; TODAY is midnight date only.
  • Fictional sample data only — names, cities and amounts are made for learning.
  • Print the revision card for NOW and stick it near your monitor for one week.
  • Ask a junior to predict the result before Enter — prediction builds judgement.
  • Note your most common mistake with this function; review it monthly.
  • Support desks in Aurangabad and Austin stamp ticket open time with NOW.
  • Excel stores dates as serial numbers; formatting only changes the display.
  • Verify with a known calendar date before trusting a long chain of date formulas.
  • Print the revision card for NOW and stick it near your monitor for one week of real worksheets.
  • When helping a junior, ask them to predict the result before pressing Enter — prediction builds judgement.
  • Keep a personal notebook of the one mistake you make most often with this function; review it monthly.
  • Share one tip from this page with a classmate in Marathi or Hindi — teaching locks the idea.
  • If a result looks wrong, check date formats and regional settings before changing the formula.
  • Date serial numbers are how Excel stores dates — formatting only changes the display.
  • Share one tip from this page with a classmate in Marathi or Hindi — teaching locks the idea.
  • Keep currency symbols consistent inside a single report column even when practice mixes ₹ $ £ € across examples.
  • Classroom habit: after NOW, open yesterday’s real workbook and find one place this function saves time.
  • For interviews, explain why calendar days and working days differ on a project that crosses a weekend.

In real work

Drill: log three ticket rows with NOW and convert one to Paste Values for an archive. Support desks in Aurangabad and Austin stamp ticket open time with NOW. Classroom drill: write three brand-new NOW formulas on a blank sheet using names from your own city — if you can invent them without the page open, you own the skill. Then break one formula on purpose and watch the error; recovering from that break is half of interview readiness. Always verify with a known calendar date before trusting a long chain of date formulas. Keep a personal notebook of the one mistake you make most often with this function; review it monthly. When Excel versions differ at home and in class, write the fallback formula under the modern one in a comment cell.

How it compares

NOW vs TODAY: NOW has date+time; TODAY is midnight date only.

Interview corner

NOW vs TODAY?
Time vs date-only.
Why freeze?
Archives must not drift.
Format tip?
Custom dd-mmm-yyyy hh:mm.

TODAY, TEXT, HOUR, MINUTE

Practice tasks (10)

  1. Task 1. Stamp open time with NOW.
    Empty ().
  2. Task 2. Format as dd-mmm-yyyy hh:mm.
    Custom format.
  3. Task 3. Build a TEXT label of NOW.
    TEXT fn.
  4. Task 4. Freeze the stamp.
    Paste Values.
  5. Task 5. Show NOW()-TODAY().
    Time fraction.
  6. Task 6. Explain TODAY vs NOW in one line.
    Interview.
  7. Task 7. Compute elapsed from a typed start.
    Subtract.
  8. Task 8. INT(NOW()) for date-only.
    INT.
  9. Task 9. Note IST policy on the sheet.
    Doc.
  10. Task 10. Bonus: hours open with [h]:mm format.
    Number format.

Quick quiz

Q1. NOW returns:
Q2. Freeze a NOW stamp by:
Q3. NOW()-TODAY() is:
Q4. Best for leave ‘as of’ day only:
Q5. Arguments for NOW:

Answers: Q1=Date and time, Q2=Paste Values, Q3=Time fraction, Q4=TODAY, Q5=None (check after you try).

Revision card

Standalone card (no tip or photo strip). QR opens this lesson. Download the PNG and revise offline.

Revision card: NOW
NOW revision card