0
0
Google Sheetsspreadsheet~15 mins

DATE function in Google Sheets - Real Business Scenario

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Scenario Mode
👤 Your Role: You are a sales analyst at a retail company.
📋 Request: Your manager wants a report showing the exact date of each sale using separate year, month, and day columns.
📊 Data: You have a table with sales data including separate columns for Year, Month, Day, and Sales Amount.
🎯 Deliverable: Create a new column that combines Year, Month, and Day into a proper date using the DATE function.
Progress0 / 4 steps
Sample Data
YearMonthDaySales Amount
2024115250
202423300
2024228450
2024310500
202445600
2024420700
202451800
2024515900
1
Step 1: Insert a new column next to the Day column and label it 'Sale Date'.
Expected Result
A new empty column named 'Sale Date' appears next to the Day column.
2
Step 2: In the first cell under 'Sale Date' (e.g., E2), enter the formula to combine Year, Month, and Day into a date.
=DATE(A2, B2, C2)
Expected Result
The cell shows the date 1/15/2024 formatted as a date.
3
Step 3: Copy the formula down the 'Sale Date' column for all rows.
Drag the fill handle from E2 down to E9.
Expected Result
All rows show the correct date corresponding to their Year, Month, and Day values.
4
Step 4: Format the 'Sale Date' column to display dates in 'MM/DD/YYYY' format for clarity.
Select the 'Sale Date' column, then Format > Number > Date.
Expected Result
Dates appear in the format like 01/15/2024, 02/03/2024, etc.
Final Result
Year | Month | Day | Sales Amount | Sale Date
---------------------------------------------
2024 | 1     | 15  | 250          | 01/15/2024
2024 | 2     | 3   | 300          | 02/03/2024
2024 | 2     | 28  | 450          | 02/28/2024
2024 | 3     | 10  | 500          | 03/10/2024
2024 | 4     | 5   | 600          | 04/05/2024
2024 | 4     | 20  | 700          | 04/20/2024
2024 | 5     | 1   | 800          | 05/01/2024
2024 | 5     | 15  | 900          | 05/15/2024
✓The DATE function successfully combines separate year, month, and day values into a proper date.
✓This makes it easier to sort, filter, and analyze sales data by exact dates.
✓Formatting the date column improves readability for reports.
Bonus Challenge

Create a new column that shows the weekday name (e.g., Monday, Tuesday) for each sale date.

Show Hint
Use the TEXT function with the format "dddd" on the Sale Date column, like =TEXT(E2, "dddd").