Excel NETWORKDAYS function: working days between dates
calc_excel_networkdaysWorking days between two dates, both included, with holidays and any weekend, as Excel's NETWORKDAYS and NETWORKDAYS.INTL.
NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays]); with the default weekend it is NETWORKDAYS. Both dates count. Negative when end is before start.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"start_date": "<start_date>",
"end_date": "<end_date>"
},
"name": "calc_excel_networkdays"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| options | No | Precision and rounding of the results (default: rounding=half_even, decimals=0). | |
| weekend | No | Weekend days, as in NETWORKDAYS.INTL: a weekend number ("1" Saturday and Sunday, "2" Sunday and Monday, ... "7" Friday and Saturday, "11" Sunday only, ... "17" Saturday only) or seven 0s and 1s starting on Monday, 1 for a weekend day ("0000011" is Saturday and Sunday). At most 7 characters. | 1 |
| end_date | Yes | End date. | |
| holidays | No | Dates that are not working days. Up to 1000 items. | |
| start_date | Yes | Start date. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| inputs | Yes | The inputs as understood. | |
| result | Yes | ||
| formula | No | ||
| receipt | No | Only with ?receipt=true: a signed receipt for this answer, a JSON Web Token signed with Ed25519 (alg EdDSA). Its claims are iss, iat, jti (the request id), endpoint, date and response (this response without the receipt). Check it with the keys at /.well-known/jwks.json or POST /v1/receipts/verify. | |
| warnings | Yes | ||
| exactness | Yes | For each decimal output: exact; rounded (correctly, to the precision); rounded_uncertified (the last digit could not be proven); or underflow (below 1e-100, reported as 0). | |
| precision | No | The precision and rounding that were applied. | |
| calculator | Yes | The calculator and version that ran. | |
| references | No |