In the pack: ChatGPT, Claude & Gemini Prompts for Data Analysis, Excel & Google Sheets
Dates, Times and Working Days Calculations
Prompt
App and version: {{SPREADSHEET_APP}}
The calculation I need (for example age, tenure, days overdue, month-end, working days between): {{DATE_TASK}}
Sample date cells exactly as they appear, including how they are formatted: {{SAMPLE_DATES}}
Weekend pattern and holiday list location, if relevant: {{CALENDAR_RULES}}
Do this:
1. First check my sample dates: say whether each looks like a real date value or text, and how I can tell with one test cell.
2. Write the formula. Use functions such as DATEDIF, EOMONTH, NETWORKDAYS.INTL, WORKDAY, or DATE as appropriate, and explain why you chose them.
3. Say whether the result counts the start day, the end day, both or neither, and how to change that.
4. Warn me about regional date format traps (day-month versus month-day) and time zones if they apply.
State your assumptions. Finish with a test using three of my sample dates and the exact result I should see for each. If my sample is not enough to decide, ask me first.
Customize this prompt
Fill in the variables below to personalize this prompt:
Model Settings
Recommended Models
Temperature
Max Tokens
Additional Notes
About this prompt
“Dates, Times and Working Days Calculations” is a free prompt for ChatGPT in the Productivity category, 184 words long, added to The Prompt Index on October 28, 2026 by The Prompt Index. Copy it with the button above, paste it into ChatGPT or any other AI chat assistant, and send it.
It has 4 placeholders to fill in first:
{{SPREADSHEET_APP}}, {{DATE_TASK}}, {{SAMPLE_DATES}}, {{CALENDAR_RULES}}.
Use the “Customize this prompt” fields to personalise it before you copy.
Recommended models: ChatGPT, Claude, Gemini.
0 upvotes, sent to an AI tool 0 times, viewed 5 times.
Browse all Productivity prompts, the AI prompt database or use the AI prompt finder to search every prompt.