No of Sundays in Month and Year

**grcshekar** · 02-02-2023, 03:48 AM

Hi how do i get output of no of sundays based on month and year
Jan-23
result is 5

**bebo021999** · 02-02-2023, 04:29 AM

What kind of month-year data? Are they real date (formated as mmm-yy) or text string?
With A1 = 01/01/2023 (first day of Jan-23) or textstring "Jan-23"

Please Login or Register  to view this content.

or with harcoded text string:

Please Login or Register  to view this content.

**grcshekar** · 02-02-2023, 04:42 AM

It is in mmm-yy format

**sandy666** · 02-02-2023, 04:44 AM

with Power Query

Please Login or Register  to view this content.

Month Name	Count Sunday
January	5
February	4
March	4
April	5
May	4
June	4
July	5
August	4
September	4
October	5
November	4
December	5
Total	53

**grcshekar** · 02-02-2023, 04:47 AM

I need formula please power query

**bebo021999** · 02-02-2023, 04:47 AM

So, Have you tried formula in #2?

**grcshekar** · 02-02-2023, 04:50 AM

Jan was example. It is in format mmm-yy

No of Sundays in Month and Year

LinkBack

Thread Tools

Rate This Thread

Display

No of Sundays in Month and Year

Re: No of Sundays in Month and Year

Re: No of Sundays in Month and Year

Re: No of Sundays in Month and Year

Re: No of Sundays in Month and Year

Re: No of Sundays in Month and Year

Re: No of Sundays in Month and Year

Thread Information

Users Browsing this Thread

Similar Threads

No of Sundays in a month from date

Count number of entries if month and year correspond to specific month and year.

[SOLVED] Number of Sundays in a Month

[SOLVED] generate all sundays for the year

Running Totals from 24 hours to month, month to year without year decreasing

If Column A Month and Year = ColumnB Todays Month and Year then send email

# of Sundays in a year

Bookmarks

Bookmarks

Posting Permissions