Supposing, I have the following two dates, and I need to count how many Sundays between them. Select a blank cell, enter below formula, and press the Enter<\/strong> key. And now you will get the number of Sundays between the two dates. See screenshot: =INT((WEEKDAY($C$2- 1)-$C$2+$C3)\/7)<\/p>\n\n\n\n Another Sample here:<\/p>\n\n\n\n =INT((WEEKDAY($C$4-1)-$C$4+$C$5)\/7)<\/p>\n\n\n\n Notes:<\/strong><\/p>\n\n\n\n (1) In the above formula, C2 is the start date and C3 indicates the end date.<\/p>\n\n\n\n (2) In above formula, 1<\/strong> stands for Sunday. And you can replace the number 1 with other numbers between 1 and 7. (1 is Sunday, 2 is Monday, 3 is Tuesday, 4 is Wednesday, 5 is Thursday, 6 is Friday and 7 is Saturday<\/strong>)<\/p>\n\n\n\n Sometimes, you may need to count the total number of a certain weekday in the given month, says count the total number of Wednesday in July, 2020. Here, I will introduce a formula to count the total number of a certain weekday in the specified month easily.<\/p>\n\n\n\n Select a blank cell, type below formula, and press the Enter key to get the counting result. =INT((WEEKDAY(DATE(G2,G3,1)- G4)-DATE(G2,G3,1)+EOMONTH(DATE(G2,G3,1),0))\/7)<\/p>\n\n\n\n Notes<\/strong>:<\/p>\n\n\n\n (1) In above formula, G2 is the specified year, G3 is the specified month, and G4 is the specified day of week.<\/p>\n\n\n\n (2) This formula assigns integers to represent day of weeks: 1 is Sunday, 2 is Monday, 3 is Tuesday, 4 is Wednesday, 5 is Thursday, 6 is Friday, and 7 is Saturday.<\/p>\n\n\n\n You can also create a User Defined Function to calculate how many specific weekdays in a given year and month besides the above formula.<\/p>\n\n\n\n 1<\/strong>. Hold down the ALT + F11<\/strong> keys, and it opens the Microsoft Visual Basic for Applications window<\/strong>.<\/p>\n\n\n\n 2<\/strong>. Click Insert<\/strong> > Module<\/strong>, and paste the following code in the Module Window<\/strong>.<\/p>\n\n\n\n Public Function TotalDays(pYear As Integer, pMonth As Integer, pDay As Integer) 3<\/strong>. Save this code and return to the worksheet, then in a blank cell, enter this formula = TotalDays(year, month, 1)<\/strong> . In this example, I will count how many Sundays there are in June 2020, so I can apply this formula as one of below formulas<\/strong>, then press Enter<\/strong> key, and you will get how many Sundays at once. see screenshots: =TotalDays(C2,C3,C4)<\/p>\n\n\n\n =TotalDays(2020,6,1)<\/p>\n\n\n\n Notes:<\/strong> This formulas use integers to represent day of weeks: 1 is Sunday, 2 is Monday, 3 is Tuesday, 4 is Wednesday, 5 is Thursday, 6 is Friday and 7 is Saturday<\/strong>.<\/p>\n\n\n\n Ref: https:\/\/www.extendoffice.com\/documents\/excel\/1421-excel-count-mondays-sundays-between-two-dates.html<\/p>\n","protected":false},"excerpt":{"rendered":" Sometimes, we need to know how many specific weekdays between two dates. For example, I have two dates: the start date is 1\/1\/2014 and the end date is 2\/15\/2014, now I want to know how many times a Sunday or a Monday or a Tuesday etc occurs in this duration. Maybe this is somewhat difficult Read More<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[10,18],"tags":[691,690],"class_list":["post-3242","post","type-post","status-publish","format-standard","hentry","category-microsoft","category-microsoft-office","tag-count-the-number-of-weekdays","tag-count-the-number-of-weekends"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\t![\"\"](\"https:\/\/cdn.extendoffice.com\/images\/stories\/doc-excel\/count-weekday-weekend\/doc-count-weekday-weekend-001.png\")
<\/p>\n\n\n\n![\"\"](\"https:\/\/SUMMALAI.COM\/wp-content\/uploads\/2021\/04\/image.png\")
<\/figure>\n\n\n\n
\n\n\n\n Use Formula To Count The Number Of Specific Weekday In Month<\/strong><\/h4>\n\n\n\n
![\"\"](\"https:\/\/cdn.extendoffice.com\/images\/stories\/doc-excel\/count-weekday-weekend\/doc-count-weekday-weekend-002.png\")
<\/p>\n\n\n\n
\n\n\n\n Use User Defined Function To Count The Number Of Specific Weekdays\/Weekends In A Given Month<\/strong><\/h4>\n\n\n\n
Dim xindex As Integer
Dim endDate As Integerend
Date = Day(DateSerial(pYear, pMonth + 1, 0))
For xindex = 1 To endDate
If Weekday(DateSerial(pYear, pMonth, xindex)) = pDay Then
TotalDays = TotalDays + 1
End If
Next
End Function<\/p>\n\n\n\n![\"\"](\"https:\/\/cdn.extendoffice.com\/images\/stories\/doc-excel\/count-weekday-weekend\/doc-count-weekday-weekend-003.png\")
<\/p>\n\n\n\n