Jun 03, 2016
If you need to generate a dynamic series of dates that are workdays only (i.e. Monday through Friday), you can do so with a simple formula that uses the WORKDAY function in Microsoft Excel.
How the formula works
In the example, A2 is the hard-coded start date and the formula in B2 is:
=WORKDAY(A2,1)
Excel solves this formula by using the WORKDAY function to return the next workday. WORKDAY is programmed to skip forward as needed to the next business day.
=WORKDAY(A2,14)
Excel solves this formula by using the WORKDAY function to return the workday fourteen days from now.
How do your Excel skills stack up?
Test NowRelated Articles
About the Author:
Alice Antonsen
Alice is one of New Horizons’ most experienced Desktop Applications trainers. She is qualified with a Diploma of Business (Computing) and a Diploma of Information Technology. Since joining New Horizons in 2006, Alice has achieved the prestigious status of a certified Microsoft Office Master and for the past 4 years, has been placed in the Top 25 Desktop Applications trainers for New Horizons Worldwide. Throughout her career, she has gained a wealth of knowledge and experience in providing training to individuals and groups of varying skill levels. Alice delivers each training session with great care and consideration ensuring each one is tailored to the learning needs of her students.
Read full bio
Next up:
- Microsoft Azure Databases
- PowerShell Basics Series– Measuring Objects (Part 1)
- Managing poor performers when counselling doesn’t help
- 4 points to consider when creating an application
- Business Connectivity Services in SharePoint
- Beguile for a while with a smile
- Creating virtual machines in Microsoft Azure
- Create with Adobe’s Capture Mobile App: Shapes
- What is Service Operation?
- Five Dimensions of Corporate Creativity
Previously
- Service Transition in ITIL®
- Lies, Damned Lies, and Statistics
- It isn’t the changes that do you in, it’s the transition
- Automatic null checking in C# 6.0
- Managing Employees through Frequent Casual Feedback
- 4 TED Talks to help you overcome stress
- What is a PCI-Express Lane?
- InDesign CC - Colour Theme Tool
- How-to: Make dates and currency in Excel show properly in a Word Mail Merge (Part 1)
- PowerShell Basics Series - Sorting and Selecting
