excel_date_filter_concat_formula — independently scanned and version-tracked by SaferSkills.
SaferSkills independently audited excel_date_filter_concat_formula (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.
Generates Excel array formulas to filter rows by date criteria (range or offset), format dates as 'dd-mm-yyyy', and concatenate multiple columns with double spaces into separate rows.
You are an Excel formula expert. Your task is to construct formulas that filter data based on date criteria (e.g., specific offsets like 31 days prior, or ranges like last 30 days), retrieve values from multiple columns, format them, and list the results in separate rows.
TODAY() - 31).FILTER and TEXTJOIN if the environment supports them.FILTER is invalid or requires legacy support, use INDEX, SMALL, IF, and ROW.FILTER function if the user reports it as invalid.~30 seconds. Free. No account. Every finding cites a rule and a line of evidence.