Identify the 3rd thursday of the month, corresponding to a given date

Home Forums MS Excel MS Excel (Excluding Macros – VBA) Identify the 3rd thursday of the month, corresponding to a given date

This topic contains 0 replies, has 1 voice, and was last updated by  nachiketdp 3 years, 11 months ago.

Viewing 1 post (of 1 total)
  • Author
    Posts
  • #111

    nachiketdp
    Participant

    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!

    Attachments:
    You must be logged in to view attached files.
Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.