{"uid":"cap_kT40Iai14BYtQccr3slJM","slug":"halowerk-workday-networkdays-calendar-reconstructor-d55b552f","name":"Halowerk Workday/NETWORKDAYS Calendar Reconstructor","description":"Reconstruct positive/negative working-day offsets and inclusive working-day counts from an explicit calendar.","url":"https://detect.halowerk.com/v1/F-TD2000-DOCUMENTS-05/xlsx-explicit-weekmask-holiday-workday-networkday-calendar?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"artifact":{"type":"object","required":["spreadsheetWorkdays"],"properties":{"spreadsheetWorkdays":{"type":"object","required":["data","claim"],"properties":{"data":{"type":"object","required":["start","end","weekend","holidays","offset"],"properties":{"end":{"type":"string","pattern":"^[0-9]{4}-[0-9]{2}-[0-9]{2}$","maxLength":10,"minLength":10},"start":{"type":"string","pattern":"^[0-9]{4}-[0-9]{2}-[0-9]{2}$","maxLength":10,"minLength":10},"offset":{"type":"integer","maximum":3660,"minimum":-3660},"weekend":{"type":"string","pattern":"^[01]{7}$","maxLength":7,"minLength":7},"holidays":{"type":"array","items":{"type":"string","pattern":"^[0-9]{4}-[0-9]{2}-[0-9]{2}$","maxLength":10,"minLength":10},"maxItems":256,"minItems":0}},"additionalProperties":false},"claim":{"anyOf":[{"type":"null"},{"type":"object","required":["networkdays","workday_date"],"properties":{"networkdays":{"type":"integer","maximum":3661,"minimum":-3661},"workday_date":{"type":"string","maxLength":20000}},"additionalProperties":false}]}},"additionalProperties":false}},"additionalProperties":false}}},"responseSchema":null,"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.003","displayCostAsset":"USDC","priceDynamic":false,"priceHint":null,"priceStatus":"priced","priceSource":"probe","requiresHandshake":false,"reviewCount":0,"rating":{"score":"0.00","successRate":"0.00","reviews":0,"stars":null,"state":"unrated"},"availabilityStatus":"unknown","priceObserved":null,"sessionDeposit":null,"pricing":{"kind":"static","summary":"$0.003/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.003","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.003","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_e6wCHb1nRKGxyDzREr-vP","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.003","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Computes working-day offsets (WORKDAY) and inclusive working-day counts (NETWORKDAYS) from a custom weekend mask, explicit holiday list, start/end dates, and an integer offset.","exampleAgentPrompt":"Starting from 2025-01-02, with weekends on Saturday and Sunday (weekend mask '0000011') and holidays on 2025-01-20 and 2025-02-17, what date falls exactly 30 working days later — and how many net working days are between 2025-01-02 and 2025-03-14?","exampleUseCases":[{"title":"Audit Excel NETWORKDAYS formula output","prompt":"I have a spreadsheet that claims there are 65 working days between 2025-03-01 and 2025-06-01, using a standard Monday-Friday week (mask '0000011') with holidays on 2025-04-18 and 2025-05-26. Can you reconstruct the correct NETWORKDAYS count and tell me if 65 is right?"},{"title":"Verify WORKDAY offset for contract deadline","prompt":"A contract starts on 2025-02-03 and the deadline is supposed to be 45 working days later. The weekend mask is '0000011' and holidays are 2025-02-17 and 2025-04-18. Can you reconstruct what the actual deadline date should be and check if the claimed date of 2025-04-07 is correct?"},{"title":"Custom weekend mask payroll calculation","prompt":"Our team works Sunday through Thursday so the weekend mask is '1000001'. Starting 2025-01-05 through 2025-04-05, with holidays on 2025-01-13 and 2025-03-30, reconstruct how many net working days fall in that range and what date is 20 working days from 2025-01-05."}],"resultDescription":"Returns the reconstructed WORKDAY date (the date that falls N working days from start) and/or the reconstructed NETWORKDAYS count (the inclusive count of working days between start and end), computed from the provided weekend bitmask and holiday list. If a claim object is provided, the response can be compared against the submitted claim values for validation.","failureModes":["Invalid date format (not YYYY-MM-DD) returns a validation error","Weekend mask not exactly 7 characters of 0/1 returns a schema error","Offset outside the range -3660 to 3660 is rejected","More than 256 holidays in the array causes rejection","Missing required fields (start, end, weekend, holidays, offset) return 400-level errors","Ambiguous or impossible calendar configurations may return unexpected results"],"whenToPreferThis":"Use this endpoint when you need to reconstruct or validate spreadsheet-compatible WORKDAY and NETWORKDAYS calculations against an explicit, fully-specified calendar — including custom weekend patterns (non-standard workweeks) and arbitrary holiday lists. Prefer it over generic date-math libraries when you need Excel/Google Sheets formula parity, auditability of claimed results, or support for non-Monday-Friday weekends.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-11-04T06:40:45.774Z","isFirstParty":false,"canonicalSlug":"halowerk-workday-networkdays-calendar-reconstructor-d55b552f"}