Need code to call a function on the first day of each month.

  • Thread starter Thread starter Guest
  • Start date Start date
Hi Paul,

If Format(Date, "d") = 1 Then
Call Procedure
End If

although this won't take into account working days, ie. if the first is on a
Sunday and the application isn't opened, then it won't fire.

Post back back if it needs to be more complex than this,

hope this helps,

TonyT..
 
Paul,

If Format(Date, "d") = "1" Then
(The Format() Function produces a string)

Or

If Day(Date)=1 then

Regards
JK
 
Thanks everyone, it worked...

JK said:
Paul,

If Format(Date, "d") = "1" Then
(The Format() Function produces a string)

Or

If Day(Date)=1 then

Regards
JK
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Message box with days of month & date. 1
Calculating first day of a month for a date field 1
Excel Monthly Spread sheet. 12
First Day Of Previous Month 4
Excel Progress Bar Showing Progress of Month 0
Reformat date to the first of the month 6
Bargain 30GB for £10 a month on a 1 month contract. 4
Query criteria to select first day of current month 1

Back
Top