Date Decomp
Upload a dataset to begin
Supported formats: .csv,.xlsx,.xls,.xlsm,.xlsb,.tsv
Sign in for free for unlimited files, no payment required.
About Date Decomp
Extract Day, Month, Year, and Weekday from dates.
The tool parses each value in your chosen date column and writes its components, day, month, year, and weekday name, into separate new columns, using the same date-parsing logic across the whole column so mixed formats are handled consistently. This turns a single opaque date string into discrete fields you can group, filter, or pivot by without writing any date-parsing formulas yourself.
Category: Transformation & LogicCommon Use Cases
- Splitting an order date column into Year and Month to build a pivot table by quarter
- Extracting Weekday from a transaction log to analyze which days have the highest sales
- Breaking out Year from a signup date column to calculate customer tenure by cohort
Key Features
- Extracts Day, Month, Year, and Weekday into separate columns
- Consistent parsing across mixed date formats in the same column
- Original date column preserved alongside the new fields
Run Datetime Reformat first if your source dates are inconsistently formatted, then decompose them here; the resulting Year/Month columns pair well with Rolling Stats for grouping trend calculations by period.
Frequently Asked Questions
Day, month, year and weekday, split out from a single date column into separate columns.
It makes it easy to group or filter data by weekday, month, or year without parsing the date string yourself.
Saves analysts from writing manual date-parsing formulas every time a report needs a weekday or month breakdown.
Read the related guide →