Managing Dates With WorkDay Function In Excel

Excel function tutorials

If you want to learn Excel, keep reading or Get 10 days of free unlimited access to for professional help and Excel Tutorials

One of the more common questions that I get is managing dates in excel. I’ve already discussed the challenges of date formats but another common use is managing dates when you need to know what the next business day will be. Why?

Because you need to know if that next day will be:

-a weekend
-a holiday

Suppose you have a cell where you write today’s date by using the today() reference as follows:

Then, in the next line you need to know what the next business day will be so you do:


And in that specific case, it would work. But that formula would not detect what type of day it is. Of course, I could use formulas such as =day(D1) which would tell me which day of the week today is.

Even better though is simply using the “workday” formula which will take out weekends.

Then, I can a holiday calendar that I will refer to in that formula as you can see here:

Easy enough? Let me know if you run into issues with this!


Look Good at Work and Become Indispensable Become an Excel Pro and Impress Your Boss


One Feedback on "Managing Dates With WorkDay Function In Excel"

Hello! Quick question that’s entirely off topic.
Do you know how to make your site mobile friendly?
My blog looks weird when viewing from my iphone 4.
I’m trying to find a theme or plugin that might be able to fix this issue.
If you have any suggestions, please share. Many thanks!


Please Leave a Comment!

Please note: Comments may be moderated. It may take a while for them to show on the page.