# Excel: How to Find the First Sunday of Each Month

You can use the following formula in Excel to find the first Sunday of a given month:

`=A2-DAY(A2)+8-WEEKDAY(A2-DAY(A2))`

This particular example returns the first Sunday of the month for the date in cell A2.

The following example shows how to use this formula in practice.

## Example: Find First Sunday of Month in Excel

Suppose we have the following list of dates in Excel: We can type the following formula into cell B2 to find the first Sunday of the month for the date in cell A2:

`=A2-DAY(A2)+8-WEEKDAY(A2-DAY(A2))`

We can then click and drag this formula down to each remaining cell in column B: Column B now contains the date of the first Sunday of each month in column A.

For example, the first date of 1/1/2023 contains the month of January for 2023.

We can confirm that 1/1/2023 is indeed the first Sunday of this month by referring to a calendar: Similarly, the next date of 2/1/2023 contains the month of February for 2023.

We can confirm that 2/5/2023 is indeed the first Sunday of this month by referring to a calendar: We can confirm that each date in column B indeed represents the first Sunday of the month for each corresponding date in column A.