🛡️Data is processed locally – We cannot see your data
Date Decomp
Upload a dataset to begin
Supported formats: .csv,.xlsx,.xls,.xlsm,.xlsb,.tsv
AboutDate Decomp
Extract Day, Month, Year, and Weekday from dates.Category: Transformation & LogicSplitting an order date column into Year and Month to build a pivot table by quarterExtracting Weekday from a transaction log to analyze which days have the highest salesBreaking out Year from a signup date column to calculate customer tenure by cohort
The Date Decomp tool is compatible with:.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.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.
Frequently Asked Questions:
What fields does it extract?
Day, month, year and weekday, split out from a single date column into separate columns.
Why would I want dates split apart like this?
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.