This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hi, I'm trying to create a budgeting spreadsheet and using the basic add 1 month formula ( "=DATE(YEAR(A1),MONTH(A1)+1,DAY(A1))" ), but I'd like a formula to add a month to the date which excludes weekends and holidays, but also takes into account those that fall on the end of the month which is not a standard date in the following month please. i.e. Any month bill that falls on the 29/30th or 31st and the following month doesn't have this date (particularly in Februarys' case.) Thanks in advance.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Excel 365 Pro Plus with Power Query.
Tables for Jan, Feb, and Mar that list all their dates,
excluding weekends and holidays.
No formulas, no VBA macro.
https://www.mediafire.com/file_premium/llnvz6c53sf547i/02_01_24.xlsx/file
https://www.mediafire.com/file_premium/ryj23gvaumf9qyw/02_01_24.pdf/file
Does this do what you want?
=WORKDAY(EDATE(A1, 1)-1, 1, Holidays)
where Holidays is a named range that contains the public holidays that you want to exclude.