Power Query function · €19
Month-end workday calendar
Plan WD-based deadlines with explicit country and fiscal settings.
Review build. Scoped native checks are listed under What you need. Full acceptance is incomplete. Purchases are disabled.
Will it fit your work?
- Your input
- A date range, country and optional first fiscal month.
- Your result
- Dates, workday counters, fiscal periods and configured national holidays.
- What you need
- Power Query. Reconcile with your local business calendar. Ran inside the Power BI model refresh; 5 boundary scenarios (incl. HU working Saturdays) passed natively in Power BI Desktop (17 Oct 2026) and Excel Power Query (19 Oct 2026).
- Check this first
- CZ, SK, PL, HU, AT and DE rules need ongoing review. Add regional holidays and company shutdowns. Hungarian shifted days are provided for 2026; verify other years.
Start with one known example
- Extract the whole ZIP and read START_HERE.md.
- Start with
Calendar_Workdays.pqon a copy. - Use the example below; replace input paths and settings.
- Reconcile rows and totals before using real data.
Calendar_Workdays(#date(2026,1,1), #date(2026,12,31), "CZ")
Each package includes the source file or workbook, its PDF guide, a short setup path, verification status and a support checklist.
Free builds are for evaluation; validate the result in your own environment. Price shown for a paid tool is the proposed one-time price, before any applicable checkout taxes.
Data stays in your own files except for configured service calls. VIES receives VAT numbers; currency services receive requested dates and currency codes. No tracking or signup is used by this static preview.