Spreadsheets and data

Free Date Difference Calculator.

Deterministic elapsed days or business days with holidays supplied.

Calculate a clearly defined date interval from the dates in your workflow and retain the assumptions with the result.

Chrome extension + account required.
25 free automation tasks/month across tools. Browser-provider limits apply.

WHAT TO HAVE READY

Two dates, timezone and inclusion rules.

YOUR STARTING POINT

A task you can make yours.

Copy it here. Paste it into WebAct when you are ready.

This page prepares your prompt. The task runs in WebAct.

01

Make the task yours.

Review the prompt above. Add your goal and any requirements that matter.

02

Bring it to WebAct.

Open WebAct, paste the task and provide the data and rules. Review any proposed calculation or code action before approving it, then check a known example.

03

Check the useful part.

Check formulas, code and calculations against known inputs in the appropriate runtime. Review actions before execution and keep the original data available.

A PRACTICAL GUIDE

How to use the Date Difference Calculator.

Date differences depend on inclusivity, timezone and business-day rules. State whether the endpoints count and supply holidays when needed.

Make the workflow fit your task.

Specify complete dates, timezone when times are involved, and whether you need elapsed or inclusive days. For business days, supply the working week and holiday calendar. Show the convention beside the answer so another reader can reproduce it.

What you provide
Two dates, timezone and inclusion rules.
What you get
Deterministic elapsed days or business days with holidays supplied.

See the input and the result.

Illustrative input and output · a teaching example, not a live WebAct run

Example input

Elapsed calendar days from 1 April to 4 April, excluding the starting instant.

Completed example

3 elapsed calendar days under the supplied date convention.
Download this example

Load this input into the prompt, then copy it to WebAct to try the task. Your result may differ from the illustration.

Decisions and troubleshooting.

How do elapsed days differ from counting both calendar dates?

From April 1 to April 4 is three elapsed days; counting each named date gives four dates. Choose the convention that fits the task.

Why does a timestamp difference change around daylight saving time?

A local calendar day need not contain exactly 24 elapsed hours. Separate calendar-day counting from duration in seconds.

Try it with your own source.

Replace the example with your material in the task prompt. Keep the requirements you need, then copy the task into WebAct.

Customize and copy the task ↑
BEFORE YOU BEGIN

Using WebAct.

The prompt and example are available here. Run your task in the WebAct Chrome extension.

Is this tool free?

You can copy and edit the prompt here for free. To use it with WebAct, install the Chrome extension, create and verify your account, and connect an available browser ChatGPT session. The Free plan includes 25 user-started automation tasks per calendar month, shared across tools. Ordinary browser Chat is separate; provider limits apply.

Learn about shared context in our privacy policy and choosing Chat or Task.

FROM A PROMPT TO YOUR OWN WORK

Bring the task to your page.

Install WebAct, add your source material and make the result yours.

Install WebAct