🧩 Date Deconstructor

Goal: Break a date into its component parts.
Useful for grouping data by Year or analyzing seasonality by Month.

2025-10-31
YEAR()
2025
MONTH()
10
DAY()
31
Ready...

💻 Formula Structure

=YEAR(serial_number)
Returns the year (1900-9999).
=MONTH(serial_number)
Returns the month number (1-12).
=DAY(serial_number)
Returns the day of the month (1-31).
-- Extracting...
=YEAR(A1), MONTH(A1)...
Extracted:
-

⚠️ Common Pitfalls

🚫 Month is a Number
MONTH() returns 10, not "October". Use the TEXT function if you need the month name.
🚫 Text Dates
These functions work best on real Serial Dates. If your date is text ("Oct 31"), they might error out or give unexpected results depending on your system settings.