Suppose you wish to know the 3rd thursday corresponding to a date. For example, if your date is 18th Feb 2018 and you are interested in knowing which is the 3rd thursday corresponding to Feb 2018. Of course, you don’t wish to do this by yourself everytime (it’s a little boring to peep into calendar and hunt for your month!). How can this be achieved through excel functions and formulas?
This query was posed to me by Miss Kavita Navlani and I could come up with the solution, as given in the attached workbook. We can make some suitable changes and identify the nth day of any month. You are requested to go through and let me know, if a better solution exists. Thanks and enjoy!