I am looking for formula that can tell me if a given daterepresents the first, second, third and so on of that particular weekday.
For instance, I have a column with a list of days (columnA), and I have a column beside that (column B) that identifies what day ofthe week that date represents via the WEEKDAY function. I am trying to figureout a formula that can take the given date and determine that it represents the1st Monday of the month, or the 3rd Thursday of theMonth, etc.
I have searched thru numerous online forums, and I haveseen multiple variants of this question, but none meet my specificrequirements. Most list the date of the 3rd Monday, but I need theinverse of this functionality. Any ideas?
For instance, I have a column with a list of days (columnA), and I have a column beside that (column B) that identifies what day ofthe week that date represents via the WEEKDAY function. I am trying to figureout a formula that can take the given date and determine that it represents the1st Monday of the month, or the 3rd Thursday of theMonth, etc.
I have searched thru numerous online forums, and I haveseen multiple variants of this question, but none meet my specificrequirements. Most list the date of the 3rd Monday, but I need theinverse of this functionality. Any ideas?