Nth *Day Of The Month Tip Posted
Today is the third Friday of the month -- which means the Tucson Old Time Music Circle is happening.
I just posted a tip that contains formulas to calculate the nth occurrence of a particular day in any month. I also include a formula to calculate the last occurrence. The tip is here: Formulas To Perform Day Of Month Calculations.
As a bonus, I threw in a fancy UI that lets the user specify the data by using drop-down lists. A humongous megaformula calculates the date, based on the input parameters (three of which are specified as text).
Spreadsheet Page Blog
Welcome to the Spreadsheet Page Blog. This is where you find the latest news on my books, add-ins, and other Excel-related topics. Comments are welcome.
All Topics
Filter by Category
Subscribe
Recent Comments
Other Blogs
2