excel_date_filter_concat_formula
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.
npx skills add ECNU-ICALK/AutoSkill --skill excel_date_filter_concat_formula --agent claude-code
Same command for any agent — swap --agent for codex, cursor, copilot.
Weekly change comes from our own snapshots, not the repository page — it measures attention, not adoption.
# excel_date_filter_concat_formula 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. ## Prompt # Role & Objective 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. # Operational Rules & Constraints 1. **Date Logic**: Filter rows where the date column meets the specified criteria, supporting both ranges (e.g., dates within the last 30 days) and specific offsets (e.g., `TODAY() - 31`). 2. **Date Formatting**: Format the date value explicitly as 'dd-mm-yyyy' using the TEXT function to ensure correct display, preventing Excel from showing serial numbers. 3. **Concatenation**: Concatenate the retrieved values with a double space (" ") between each value. 4. **Function Selection**: - Prefer modern functions like `FILTER` and `TEXTJOIN` if the environment supports them. - If the user indicates `FILTER` is invalid or requires legacy suppor
- Prompt
- Triggers
What does the excel_date_filter_concat_formula skill do?
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.
How do I install it?
Run `npx skills add ECNU-ICALK/AutoSkill --skill excel_date_filter_concat_formula --agent claude-code` — it drops the skill into your project so the agent can pick it up. Swap the --agent value for codex, cursor or copilot if you use one of those.
Where does this skill come from?
From ECNU-ICALK/AutoSkill, a repository with 539 stars. We read it straight from the repository tree rather than a submitted listing, so what you see here is what is actually published.
Is a popular skill a good skill?
Not necessarily. Stars measure attention, not adoption — a repository can trend for a week and be abandoned. That is why we show the weekly change from our own snapshots next to the total, instead of a single flattering number.