Hi - Dave here.
Happy Friday!
In my last email, I shared a
simple formula to generate a list of sequential dates.
This works great if you want
all days. But what if you need to list
workdays only?
This is a more complicated problem because we must exclude weekends and holidays. The best function for this in Excel is WORKDAY.INTL.
The WORKDAY.INTL function takes a date and returns the next workday based on a given offset. WORKDAY.INTL will automatically exclude weekends and can optionally exclude holidays.
To generate a dynamic list of workdays, we can combine WORKDAY.INTL with SEQUENCE as seen in the workbook below:
[
Download the workbook and read the full explanation]
WORKDAY.INTL will exclude Saturdays and Sundays by default, but you can configure WORKDAY.INTL to exclude
any day(s) you like. The SEQUENCE function requires Excel 2019 or later, but the attached worksheet contains formulas that will work fine in older versions of Excel. Click the link above to read the full explanation and download the workbook.
Excel formulas
We maintain a list of over 500 working formulas
here.
If you need more structure, we also offer
video training.
Have a great weekend!
Dave
