Calculate number of Sundays in the month

In Microsoft Excel I am looking to determine the number of Sundays in any given month. I am putting together a budget spreadsheet and some of the sub accounts get extra funding when five Sundays are in the month instead of four.

The only cell I have to reference is the title of the sheet which is in Cell A1 and equals the current month. For Example 6/1/14

Try this where A1 is the starting day of the month:

=SUMPRODUCT(N(TEXT(ROW(INDIRECT(A1&":"&EOMONTH(A1,0))),"ddd")="Sun"))

You can also use this for any day of the week just change "Sun" and any date range by replacing A1 with start date and EOMONTH(A1,0) with end date.

If the date you mention is always the first of the month, then this one will also work:

=INT((WEEKDAY(A1-1)+EOMONTH(A1,0)-A1)/7)