Working days between two dates, Philippine holidays excluded.
What it's for
Count the working days between two dates, leaving out your rest days and the Philippine holidays that land on days you work — for a deadline, a leave application or a pro-rated payment.
Before you start
Have the first and last day of the period, and know which days of the week you normally work and whether your workplace works on special non-working days.
Enter the period
Pick the first day in From and the last day in To. Both of those days are counted.
Tap the days you work
Under Days worked, tap each day of the week you normally work so it is highlighted, and tap again to remove one. Monday to Friday is set to start with; add Sat for a six-day week.
Decide about special days
Leave Treat special non-working days as days off ticked if your workplace closes on them. Untick it if you work them — many workplaces do, because an unworked special day is unpaid. Regular holidays on your working days are always taken off.
Press Calculate
Press Calculate. The answer already updates as you choose; the button brings it into view.
See which holidays were left out
Press Show the holidays in this range for each holiday's date, name and type. One marked provisional is a date set by the yearly proclamation rather than fixed by law.
Reading the result
If it goes wrong
Almost every hand-worked answer to this question makes one of two mistakes, and they run in opposite directions — so a count that makes both can come out right by accident.
The first: subtracting two dates measures the gap, not the days. 1 to 5 December is five days, but 5 − 1 is four. Every count here includes both the first day and the last.
The second: a holiday that fell on a rest day removes nothing. If Christmas is a Sunday and you work Monday to Friday, it costs you no working day at all. This page reports how many holidays landed on your rest days so you can see it rather than take it on trust.
And a third thing that trips people: a regular holiday and a special non-working day are not the same. Unworked, a regular holiday pays a full day and a special day pays nothing. Because a special day pays nothing, a great many workplaces simply work them — so it is a switch above rather than an assumption made for you.
Yes. 1 to 5 December is five days, not four. Subtracting one date from the other gives four, which is why a hand-worked answer to this question is so often one short — the subtraction measures the gap between the days rather than the days themselves. Every count on this page includes both endpoints.
Nothing is subtracted for it, because it was never a working day. If Christmas falls on a Sunday and you work Monday to Friday, it costs you no working day at all. Subtracting it anyway is the other common error, and it runs in the opposite direction to the endpoint mistake — so a count that makes both can come out right by accident. The page reports how many holidays fell on your rest days so you can see it happening.
They are opposite. An unworked regular holiday pays a full day’s wage; an unworked special non-working day pays nothing, on the no-work-no-pay principle. Both arrive on the same annual proclamation and both are commonly called “holidays”, which is why they are so often conflated. Because a special day pays nothing, many workplaces simply work them — so whether to exclude them is a switch on this page rather than an assumption.
The twelve regular holidays and the four fixed special non-working days set by law — RA 9492, RA 9849 and RA 10966. Maundy Thursday, Good Friday and Black Saturday are computed from the date of Easter, and National Heroes Day is the last Monday of August. Eid’l Fitr and Eid’l Adha follow the Islamic lunar calendar and are declared each year after the new moon is observed, so they are the two dates this page can show only provisionally until the proclamation is published.
Because two of the regular holidays cannot be computed. Eid’l Fitr and Eid’l Adha are proclaimed annually on the recommendation of the NCMF, so a year without its proclamation loaded would be answered from the recurring holidays alone — missing two regular holidays and any special day declared that year, with nothing about the number looking wrong. Refusing is the honest answer; a plausible count that is quietly two days out is not.
Yes, and you should if that is your week. A Monday-to-Saturday week is ordinary in Philippine retail, construction and many support operations, so the days you work are checkboxes rather than a fixed Monday-to-Friday assumption. You can switch any day on or off, including an unusual pattern such as a Tuesday-to-Saturday week.
No — that is the Holiday Pay Calculator, which applies the statutory multipliers. This one counts days. The two rest on the same distinction between regular holidays and special non-working days, which is why they sit beside each other.
A day is counted once. A holiday on a rest day is already counted among the rest days and is never subtracted twice.
Seven are fixed dates — New Year’s Day, Araw ng Kagitingan, Labor Day, Independence Day, Bonifacio Day, Christmas, Rizal Day. Three are derived — Maundy Thursday and Good Friday from the date of Easter, and National Heroes Day as the last Monday of August. And two are proclaimed each year — Eid’l Fitr and Eid’l Adha, which follow the lunar calendar and cannot be computed in advance.
That is why the calculator refuses a year with no proclamation loaded: an answer built from the recurring list alone would be missing two regular holidays, and nothing about the number would look wrong.
Important
An estimate for planning. Regular holidays and fixed special days are set by law, but the annual proclamation can add, move or declare further non-working days — and the two Eid dates are confirmed only after the new moon is observed. Check the proclamation for anything that depends on an exact date. Nothing you type here is sent to our servers — the calculation runs entirely in your browser.
