{"id":1919,"date":"2022-08-07T10:34:23","date_gmt":"2022-08-07T07:34:23","guid":{"rendered":"https:\/\/www.addictivetips.com\/?p=275407https:\/\/www.addictivetips.com\/microsoft-office\/find-date-of-day-of-the-month-in-excel\/"},"modified":"2022-08-07T10:34:23","modified_gmt":"2022-08-07T07:34:23","slug":"how-to-find-the-date-of-a-specific-day-of-the-month-in-excel","status":"publish","type":"post","link":"https:\/\/tojikon.net\/en\/1919-how-to-find-the-date-of-a-specific-day-of-the-month-in-excel\/","title":{"rendered":"How To Find The Date Of A Specific Day Of The Month In Excel"},"content":{"rendered":"

If you use Excel to maintain schedules and\/or time sheets, you might have needed to find the date of a specific day of the month. For example, what date does the second Monday of the month fall on? If you ever need to look up this same information but don\u2019t want to use a calendar to do it, there\u2019s a simple formula that you can use instead.<\/p>\n

Variables<\/h2>\n

We\u2019re dealing with the days in a week, and the months in a year so while there are variables in this formula, their scope is limited. That said, we\u2019re going to give you the formula and explain which variable is which.<\/p>\n

Year:<\/strong> The year of the month you want to look up the date for.<\/p>\n

Month:<\/strong> The month you want to look up the date for.<\/p>\n

Day of week:<\/strong> The day of the week you want to look up the date for.<\/p>\n

Occurrence:<\/strong> The occurrence of the day i.e., first Monday, or second Friday, or third Wednesday.<\/p>\n

These variables aren\u2019t going to be used by name. All you can do is use cell addresses however, the formula will be much easier to customize for your own needs when it\u2019s properly formatted. The above variables will act as column headers so that it\u2019s easier for you to understand what is going on and edit the formula.<\/p>\n

Formula<\/h3>\n

The generic formula is as follows however you will need to edit it with the example given so that it can return a date. Paste the following in an empty cell and use the example to edit it accordingly.<\/p>\n

=DATE(A8,B8,1+7*D8)-WEEKDAY(DATE(A8,B8,8-C8))<\/pre>\n
Example<\/h3>\n
Months are numbered 1-12 starting with January. Days of the week are numbered 1-7 starting with Sunday which means Sunday is equal to 1, Monday is equal to 2, Tuesday is equal to 3, and so on.<\/p>\n
In the above formula, the values that need to be edited to your needs are;<\/p>\n
A8, B8, D8, and C8.<\/p>\n
A8 = Year, B8 =\u00a0Month, C8 =\u00a0Day of week, and D8 =\u00a0Occurrence<\/p>\n
\"\"<\/span><\/p>\n
The editing is the only tricky part but once you\u2019ve figured that out, it\u2019s going to be easy to use this formula. It comes from Superuser user\u00a0ale.<\/p>\n
If you\u2019re nervous about whether or not you\u2019ve edited the values correctly, try a few out and use a calendar to check if you\u2019re getting the correct results. The only confusing bit is between the day of the week and its occurrence. Remember that the value for the day of the week can be as high as 7 whereas its occurrence cannot go above 5.<\/p>\n","protected":false},"excerpt":{"rendered":"
If you use Excel to maintain schedules and\/or time sheets, you might have needed to find the date of a specific day of the month. For example, what date does the second Monday of the month fall on? If you ever need to look up this same information but don\u2019t want to use a calendar …<\/p>\n","protected":false},"author":1,"featured_media":1920,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[23],"tags":[36],"_links":{"self":[{"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/posts\/1919"}],"collection":[{"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/comments?post=1919"}],"version-history":[{"count":0,"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/posts\/1919\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/media\/1920"}],"wp:attachment":[{"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/media?parent=1919"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/categories?post=1919"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/tags?post=1919"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}