display no of sundays and its date

With
A1: a first of month date.....01-Jan-2015

This formula returns the first Sunday date of that month

Please Login or Register  to view this content.

and this formula, copied across to the right, returns the successive Sundays in that month

Please Login or Register  to view this content.

Is that something you can work with?

This is a bit different approach.

With the first days of the month in column A enter this array-entered formula in B1 fill down and across until you get blanks.

Formula:

Please Login or Register  to view this content.

If you aren’t familiar with array-entered formulas array enter means the formula must be committed by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.

A workbook is attached.

Thank u very much.
what changes we should do if we want to get other weekday ie monday or wednesday... as users choice?

In my formula change the "=1" to "=2" for Mondays and "=4" for Wednesdays, or better yet designate a "helper cell" (say H1) and then reference that helper with "=H1" and put the appropriate DOW number there. BTW: This assumes the reference type in the second argument of WEEKDAY is set to one.

In the formula I posted: =WORKDAY.INTL($A1-1,1,"1111110")
In this section "1111110", 1's define non-workdays, beginning with Monday.
In that example, Monday through Saturday are non-workdays...The zero represents Sunday (a work day)

If you want to list Mondays...use this: "0111111"

Does that help?

A more flexible version of the formula I posted

A1: a day to list....Monday
A2: a first of the month date....01-Jan-2015

This formula list the first date of the A1 day for that month

Please Login or Register  to view this content.

and this formula, copied across, lists the successive dates

Please Login or Register  to view this content.

Does that help?