Is Date Odd or Even?

G

Guest

Hi All.........
I am trying to create a macro that will test the DATE, and if it is an ODD
number, run Macro1, and if it is an EVEN number, run Macro2........

Can't seem to get there.......help please.

Vaya con Dios,
Chuck, CABGx3
 
D

Dave Peterson

Based on the day?

if day(date) mod 2 = 1 then
call OddMacro
else
call EvenMacro
end if
 

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

Top