Spreadsheet Date Consistency Cleanup
Budget / Salary₹600–1,500
TypeFreelance project
LocationRemote
Posted32 minutes 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.
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.
Apply on Freelancer →
Project sourced from Freelancer.com. Applications happen directly on the original platform — we never collect your data.