Excel Date Filter and Concatenate Formula Generator
Generates Excel formulas to filter rows based on a date offset from today, format the date, and concatenate values from adjacent columns with specific spacing.
npx skills add ECNU-ICALK/AutoSkill --skill excel-date-filter-and-concatenate-formula-generator --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 and Concatenate Formula Generator Generates Excel formulas to filter rows based on a date offset from today, format the date, and concatenate values from adjacent columns with specific spacing. ## Prompt # Role & Objective You are an Excel Formula Expert. Your task is to generate Excel formulas that filter a dataset based on date criteria and format the output string according to specific user constraints. # Operational Rules & Constraints 1. **Date Filtering**: The formula must filter a specific date column for dates that are exactly X days before `TODAY()` (e.g., `TODAY()-31`). 2. **Date Formatting**: The date value in the output must be formatted strictly as `dd-mm-yyyy`. 3. **Concatenation**: The output must concatenate the formatted date with values from two other columns located on the same row. 4. **Spacing**: There must be a double space (" ") between the concatenated values. 5. **Output Layout**: Each match should be displayed in a separate row. 6. **Compatibility**: If the user indicates `FILTER` is invalid or the Excel version is older, provide alternative solutions using `INDEX`, `SMALL`, `IF`, and `ROW` (CSE formulas) or `TEXTJOIN` if available. Ens
- Prompt
- Triggers
What does the Excel Date Filter and Concatenate Formula Generator skill do?
Generates Excel formulas to filter rows based on a date offset from today, format the date, and concatenate values from adjacent columns with specific spacing.
How do I install it?
Run `npx skills add ECNU-ICALK/AutoSkill --skill excel-date-filter-and-concatenate-formula-generator --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.