For a recent project, I needed a list of every Friday in 2018. I found a couple of ways to accomplish this.

The easiest was through the website Research Manics which has a Days By Year page that will let you select any day of the week and any year from 2000-2100 and then return a list of all Mondays or Fridays or whatever for that year.

This can also be done in Excel using formulas via a method documented at ExtendOffice.Com

- Create a new sheet and in CELL A1 enter the first day of whatever year it is you’re interested in.
- In CELL B1 use one of the formulas below, which will give you the first Monday or Tuesday or whatever of the year in CELL A1
- Then, simply drag and fill the formula in B1 down as many cells as you need.

Mondays

` =IF(WEEKDAY(EOMONTH(A1,-1)+1)=2,EOMONTH(A1,-1)+1,EOMONTH(A1,-1)+(8 + MOD(2,7))-WEEKDAY(EOMONTH(A1,-1)+1))`

Tuesdays

`=IF(WEEKDAY(EOMONTH(A1,-1)+1)=3,EOMONTH(A1,-1)+1,EOMONTH(A1,-1)+(8 + MOD(3,7))-WEEKDAY(EOMONTH(A1,-1)+1))`

Wednesdays

`=IF(WEEKDAY(EOMONTH(A1,-1)+1)=4,EOMONTH(A1,-1)+1,EOMONTH(A1,-1)+(8 + MOD(4,7))-WEEKDAY(EOMONTH(A1,-1)+1))`

Thursdays

`=IF(WEEKDAY(EOMONTH(A1,-1)+1)=5,EOMONTH(A1,-1)+1,EOMONTH(A1,-1)+(8 + MOD(5,7))-WEEKDAY(EOMONTH(A1,-1)+1))`

Fridays

`=IF(WEEKDAY(EOMONTH(A1,-1)+1)=6,EOMONTH(A1,-1)+1,EOMONTH(A1,-1)+(8 + MOD(6,7))-WEEKDAY(EOMONTH(A1,-1)+1))`

Saturdays

`=IF(WEEKDAY(EOMONTH(A1,-1)+1)=7,EOMONTH(A1,-1)+1,EOMONTH(A1,-1)+(8 + MOD(7,7))-WEEKDAY(EOMONTH(A1,-1)+1))`

Sundays

`=IF(WEEKDAY(EOMONTH(A1,-1)+1)=1,EOMONTH(A1,-1)+1,EOMONTH(A1,-1)+(8 + MOD(1,7))-WEEKDAY(EOMONTH(A1,-1)+1))`

### Like this:

Like Loading...

*Related*