How many thursdays are in a month

I have a list of the past 12 months see below and I need to be able to determine which of of those months had 5 Thursdays in them.

Any suggestions on how to do this? Excel Facts. When did Power Query debut in Excel? Click here to reveal answer. Dave Patton Well-known Member. If you do not want to extend the list or if you wish to show the date for the end of the month B1 , you can revise the formula. Joined Jun 11, Messages How about this suggest? Joined Sep 11, Messages Joined Jan 9, Messages 14, End xlUp.

I appreciate all of your suggestions. I tried each and and tweak to fit my needs and got it to work. Thanks for the help PatrickOfLondon New Member. Joined Nov 29, Messages 7. Click to expand Last edited: May 30, Biz Well-known Member. Another easier approach Code:. Last edited: May 31, If I am not mistaken, this function will also work same setup as for Biz's function You must log in or register to reply here. Similar threads T. Question Enter the first of the month and list days in that month.

Tomwhite Oct 18, Excel Questions. Replies 6 Views Oct 19, Fluff. Question Excel Datedif function - inconsistent in some dates. Replies 1 Views The answer to this question is not always simple. Most of the time, it will equal the number of weeks in a year, but that's only true for some of the days of the week.

Most years have days, but a leap year has days. That adds up to 52 weeks where each week is exactly 7 days PLUS 1 or 2 additional days. The year has exactly days. Now if the year starts on a Thursday in a non-leap year, you end up with 53 Thursdays. Or if either of the first two days lands on a Thursday during a leap year, then you can also get 53 Thursdays. Check the calendars below for January and December of to see exactly where the year starts and ends.