We all know that networkdays() an extremely powerful and simple excel formula can help you calculate no. of working days between 2 given dates.
But there is one problem with it. It assumes 5 day workweek starting with Monday to Friday. Not all countries have workweek from Monday to Friday. As Incubus wrote to me in an e-mail,
In Excel, the function “networkdays” doesn’t work for users in the middle east ‘cos it counts Saturday & Sunday as weekend. This is good enough only if you live in elsewhere, but for us weekend is Friday & Saturday.
This got me thinking and I ended up writing a user defined formula (UDF) to calculate working days between 2 given dates with any criteria. This will be good for calculating payrolls for temporary workers, offshore partners and of course people working countries where Saturday or Sunday or not usually holidays.
Please download the NetWorkingDays Add-in if you want to use this function.
If you are curious what is inside, see the UDF code
How to use the NetWorkingDays() UDF?
Once you download the add-in, just install the add-in by,
- [in Excel 2003] By going to Tools > Addins > Browse
- [in Excel 2007] By going to Office Button > Excel Options > Addins > “Go button” > Browse
- Specify the location where you saved the downloaded file
Now that the add-in is installed, you can use the UDF by writing a formula like this:
=networkingdays("01-06-2009","02-07-2019","12356")
The first argument is start date, the second one is end date and third one tells which days of week are working (Monday is 1 and Sunday is 7). So the above formula counts all the Mondays, Tuesdays, Wednesdays, Fridays and Saturdays between 01-06-2009 and 02-07-2019
Known Errors and Limitations
The formula returns #VALUE! error when you try really long durations (like trying to find all the workingdays between now and a century later)
Another thing is, you cannot feed a custom holiday list to this formula. But that is very easy to add on, so I didn’t bother.
So go ahead and give it a try
Download the NetWorkingDays() UDF Excel Add-in
and tell me what you think…
On dates and times in Excel: Date & Time Formulas | 10 Tips on Using Dates & Times in Excel
11 Responses to “FREE Calendar & Planner Excel Template for 2025”
Hi,
I downloaded this 2025 Calendar template. I checked the custom tab. Is it possible to change the weekend Fri & Sat.
Thanks
It is. Just use the option for fri & sat weekend (should be 7).
Activities of some dates are not getting displayed on "Any month" and "printable calendar" sheets.
e.g. Activity of 24 Apr 25.
Can you check again? The date in "planner" sheet should be a proper date. When I tested with 24-apr-2025, it works.
Love this calendar... I have highlight planner dates enabled but all dates are blue, is it possible to customize the color based on the type assigned to each date?
What would be the right way to add more Holidays in the Customizations?
Inserting rows in the Holiday List causes the blank cells in the calendar to turn Blue.
This is amazing!!! The best I've seen so far!! Is it possible to update it to consider a column for the final date? That way, if an event lasts more than one day, it repeats in the calendar
How do we change/insert the customization "Icon Options" ?
You can adjust these from the settings tab.
Is there anyway this can turn into an academic calendar (ie. start month is July and runs all the way through June of next year)?
Is there a way to make it something that is more than a day without having to add it to every day of that week.