<div>
=if(TEXT(today(),&quot;d&quot;)=&quot;1&quot;,<wbr />do this, else do that)
</div>


=if(TEXT(today(),"d")="1",do this, else do that)

<div>
and finally Seamus.....<br />
<br />
If Day(Now())=1 then .....<br />

</div>


and finally Seamus.....

If Day(Now())=1 then .....


<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I need a piece of code to put in my workbook open that says <br />
<br />
if today = 1st day of month call sub xyz<br />
<br />
Anyone any ideas?<br />
<br />
Thanks<br />
Seamus
</div>
</div>


Hi,

I need a piece of code to put in my workbook open that says 

if today = 1st day of month call sub xyz

Anyone any ideas?

Thanks
Seamus

Is today beginning of month?

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