<div>
With C1 established by Thomas' formula, you can use in B1<br />
<br />
=C1+MOD(8-WEEKDAY(C1,2),7)<wbr /><br />
<br />
or<br />
<br />
=C1+IF(2 &lt;&nbsp;WEEKDAY(C1), 7 - WEEKDAY(C1) + 2, 2 - WEEKDAY(C1))<br />
<br />
cheers, teylyn
</div>


With C1 established by Thomas' formula, you can use in B1

=C1+MOD(8-WEEKDAY(C1,2),7)

or

=C1+IF(2 < WEEKDAY(C1), 7 - WEEKDAY(C1) + 2, 2 - WEEKDAY(C1))

cheers, teylyn

<div>
My take on B1<br />
=MOD(9-WEEKDAY(DATE(YEAR(A<wbr />1),MONTH(A<wbr />1),1)),7)+<wbr />DATE(YEAR(<wbr />A1),MONTH(<wbr />A1),1)<br />
<br />
Thomas
</div>


My take on B1
=MOD(9-WEEKDAY(DATE(YEAR(A1),MONTH(A1),1)),7)+DATE(YEAR(A1),MONTH(A1),1)

Thomas

<div>
<div class="content wysiwyg-content">
IF A1 =Today()<br />
<br />
Is there a formula I can place in:-<br />
<br />
B1 - To equal the very first Monday of the given month<br />
C1 - The first day
</div>
</div>


IF A1 =Today()

Is there a formula I can place in:-

B1 - To equal the very first Monday of the given month
C1 - The first day

excel formula

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.