Drag across to calculate first Monday of each month

[accordingly]

I need a formula I can drag across multiple columns, which will calculate the first Monday of the month increasing by one month each column. So far I've come up with the following, which seems to work but is over-engineered and I'm worried about it slowing down the rest of my sheet. Does anyone have something better or a way to simplify this?

K1 contains "2018-01-01" (which happens to have been a Monday this year, but this formula would be better if I wasn't relying on a starter hard-coded cell like this)

L1 contains =IF(DAY(EDATE(K1,1)+6)-WEEKDAY(EDATE(K1,1)+6,3)<8,(EDATE(K1,1)+6)-WEEKDAY(EDATE(K1,1)+6,3),(EDATE(K1,1)+6)-WEEKDAY(EDATE(K1,1)+6,3)-7)


Thanks in advance!

 

[Eric W]

Try:

=EOMONTH(K1,0)+8-WEEKDAY(EOMONTH(K1,0)+1,12)

 

[accordingly]

Brilliant - thank you, Eric! I knew there was a cleaner way to get this done.

 

[lrobbo314]

Eric W, I like yours better, but since I went to the trouble of figuring it out, I'll share mine anyway.

​=(EOMONTH(K1,0))+CHOOSE(WEEKDAY(EOMONTH(K1,0),2),7,6,5,4,3,2,1)

 

[Eric W]

Glad we could help!