Spreadsheet Date Consistency Cleanup

via Freelancer ·

Budget / Salary₹600–1,500
TypeFreelance project
LocationRemote
Posted1 hour ago
I have a working spreadsheet that’s starting to feel chaotic because dates and times appear in several different formats. The priority is to make every date- and time-related cell consistent throughout the file. I want everything converted to the Day/Month/Year style (e.g., 06/11/2026). While you work, please keep the original information intact—only change the cell formatting or transform the raw values when required so that formulas, references, and data integrity remain untouched.

Scope
• Identify every column, row, or hidden sheet where a date or time is stored.
• Convert all of them to the DD/MM/YYYY format, applying a matching time format when hours or minutes are present.
• Spot and correct any obvious entry errors that prevent proper conversion (for example “32/13/23” or text masquerading as dates).
• Preserve non-date fields exactly as they are; no other cleanup is necessary right now.

Deliverable
A cleaned version of the spreadsheet, ready for import or further analysis, with dates and times displaying uniformly in the specified format and no broken formulas.
visual basic data processing excel vba excel macros data management
Apply on Freelancer →

Project sourced from Freelancer.com. Applications happen directly on the original platform — we never collect your data.