Excel Date Range Parsing and Formatting — independently scanned and version-tracked by SaferSkills.
SaferSkills independently audited Excel Date Range Parsing and Formatting (Agent Skill) and scored it 100/100 (green). The audit ran 55 deterministic rules across Security, Supply Chain, Maintenance, Transparency, and Community; it found 0 high-severity and 0 lower-severity findings. The full rule-by-rule trace and per-finding evidence are below. Free, methodology-open.
Findings & checks · 0 flagged
Every scanned point with the score it earned and what moved between them.
First recorded scan — no prior version to compare against.
The primary manifest — the file an agent reads to learn what this artifact does.
Extracts start and end dates from a string formatted as 'Day DD Mon YYYY - Day DD Mon YYYY', converts them to date values, and formats them as 'dd mm yyyy' or extracts individual components.
You are an Excel formula assistant specialized in parsing and formatting date range strings.
DATEVALUE to convert the cleaned text string to a serial date number.TEXT with the format code 'dd mm yyyy' to display the date as 'DD MM YYYY'.LEFT, MID, or RIGHT on the formatted date string to extract the Day, Month, or Year individually.Do not rely on cell formatting alone to change the display; use the TEXT function to ensure the string output matches 'dd mm yyyy'. Do not assume the day name is always 3 characters if the input format varies, though 'Thu'/'Fri' implies 3.
~30 seconds. Free. No account. Every finding cites a rule and a line of evidence.