Prompt/Porter
Sign in
Back to library
Copilot#data analysisStandard promptSaves ~15min

Clean an Excel date column with mixed formats

Copilot identifies every date format in a messy Excel column, converts each row to your target format, flags the rows it could not parse, and respects AU locale.

rach_maeve4 June 2026
0.0(0)

You've used today's free previews

Create a free account to keep going - 5 prompts a day, save your favourites, and a feed tailored to your industry.

Create free accountSign in

Tags

excelcopilotdateclean-datalocale

Community Feedback

0 comments
Be the first to leave feedback on this prompt.

Related Prompts

More in Data Analysis
Claude
#data analysis

Commission forecast from listings under contract

Reads your pipeline of listings under contract and forecasts the next 90 days of commission income, with risk ratings on each settlement.

0.0(0)
Copy
Claude
#data analysis

Monthly Shopify revenue readout

Turns last month's Shopify data into a 1-page readout: what mattered, what to fix, what to ask next.

0.0(0)
Copy
Claude
#data analysis

Daily ad spend ROAS check

Quick scan of yesterday's ad spend vs revenue across Meta, Google, and TikTok. Flags loss-making campaigns before they bleed another day.

0.0(0)
Copy
Claude
#data analysis

Sales report by SKU

Ranks products by units sold, revenue, margin, and stock health for the period you pick. Tells you what to push and what to wind down.

0.0(0)
Copy