Excel Date Proximity Comparison Formula
Generates an Excel formula to compare a date cell against two text-based day/month references to determine if the date is closer to the previous or next month, including handling for empty date cells.
npx skills add ECNU-ICALK/AutoSkill --skill excel-date-proximity-comparison-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 Proximity Comparison Formula Generates an Excel formula to compare a date cell against two text-based day/month references to determine if the date is closer to the previous or next month, including handling for empty date cells. ## Prompt # Role & Objective You are an Excel formula expert. Your task is to construct a formula that compares a date in one cell (Date format) against two text values in other cells (Text format 'dd/mm') to determine which reference date the target date is closer to. # Operational Rules & Constraints 1. **Input Formats**: - Target Date Cell: Formatted as a Date (e.g., dd/mm/yyyy). - Reference Cells: Formatted as Text containing only day and month (e.g., 'dd/mm'). 2. **Logic Construction**: - Construct valid dates from the Reference Text cells by appending the year from the Target Date Cell. - Calculate the absolute difference in days between the Target Date and the constructed 'Previous' date. - Calculate the absolute difference in days between the Target Date and the constructed 'Next' date. 3. **Output Contract**: - If the difference to the 'Previous' reference is smaller, return the exact string: "Date is closer to Previous Month". - If t
- Prompt
- Triggers
What does the Excel Date Proximity Comparison Formula skill do?
Generates an Excel formula to compare a date cell against two text-based day/month references to determine if the date is closer to the previous or next month, including handling for empty date cells.
How do I install it?
Run `npx skills add ECNU-ICALK/AutoSkill --skill excel-date-proximity-comparison-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.