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).
- Reader Comments -
Following are comments in response to this item.
The most recent comment is at the bottom.
- By Ron de Bruin. Comment posted 21 September, 2008 11:11amHi all
Tip: If you want to filter on the Nth day in the month in a column with dates you can use my EasyFilter Add-in(there is no 2007 version on this moment).
http://www.rondebruin.nl/easyfilter.htm
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.