TODAY and NOW in Google Sheets - Real Business Scenario

Scenario Mode

👤 Your Role: You are a sales assistant at a retail company.

📋 Request: Your manager wants a daily sales report that shows the current date and time automatically, along with sales data for the day.

📊 Data: You have a table with sales transactions including product names, quantities sold, and sales amounts. The date and time of the report should update automatically each time the sheet is opened.

🎯 Deliverable: Create a sales report sheet that displays the current date using TODAY(), the current date and time using NOW(), and summarizes total sales for the day.

Sample Data

Transaction ID	Product	Quantity	Sale Amount	Sale Date
1001	Notebook	3	15	2024-06-01
1002	Pen	10	5	2024-06-01
1003	Backpack	1	40	2024-06-02
1004	Notebook	2	10	2024-06-02
1005	Pen	5	2.5	2024-06-03
1006	Backpack	2	80	2024-06-03
1007	Notebook	1	5	2024-06-04
1008	Pen	7	3.5	2024-06-04

1

Step 1: In cell G1, enter the formula to show the current date that updates automatically.

=TODAY()

Expected Result

2024-06-04 (or the current date when opened)

2

Step 2: In cell G2, enter the formula to show the current date and time that updates automatically.

=NOW()

Expected Result

2024-06-04 14:30 (or current date and time when opened)

3

Step 3: In cell G4, calculate the total sales amount for the current date using the sales data and the TODAY() function.

=SUMIF(E2:E9, G1, D2:D9)

Expected Result

8.5 (sum of sales amounts for 2024-06-04)

4

Step 4: Label cells F1, F2, and F4 as 'Current Date', 'Current Date & Time', and 'Total Sales Today' respectively for clarity.

Enter text labels manually in cells F1, F2, and F4.

Expected Result

F1='Current Date', F2='Current Date & Time', F4='Total Sales Today'

Final Result

Current Date       | 2024-06-04
Current Date & Time| 2024-06-04 14:30
Total Sales Today  | 8.5

Sales Data Table Below

✓The report shows the current date and time automatically.

✓Total sales for the current date (2024-06-04) is 8.5.

✓The TODAY() function updates the date daily without manual changes.

✓The NOW() function updates the date and time whenever the sheet recalculates.

Bonus Challenge

Create a dynamic summary that shows total sales for the last 7 days including today.

Show Hint

Use SUMIFS with a date range condition comparing Sale Date to TODAY() and TODAY()-7.