Is today beginning of month?

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
Seamus2626Asked:
Who is Participating?
 
RunriggerCommented:
sorry, code version....

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

0
 
RunriggerCommented:
=if(TEXT(today(),"d")="1",do this, else do that)
0
 
RunriggerCommented:
and finally Seamus.....

If Day(Now())=1 then .....
0
 
Seamus2626Author Commented:
Thanks Runrigger!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.