View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default Is Date Odd or Even?

So cool it is.................thanks Dave

Vaya con Dios,
Chuck, CABGx3




"Dave Peterson" wrote:

Based on the day?

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



CLR wrote:

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


--

Dave Peterson