How to calculate n-th day of week in month (and other spreadsheet date functions)

[Joseph_Accountant]

Hi Ockert,

I shared a showcase recently that may help. My purpose is very different so it would require some customization from you, but maybe you can glean some valuable information from my shared solution?

Accounting Business Day Calculator

Hello Makers - I wanted to share my solution for a business day calculator. I support Accounting & Finance teams, and it is common to build notifications and due dates based on the business day for accounting close. I built something similar to this before in a different program using arrays + select formulas, but I really enjoyed building a solution in Make that writes the data to a Google Sheet so that the team can always see the schedule. Here is the blueprint you can upload to your Make en…

Hope this helps!
-Joe