Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is Date Odd or Even?
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is Date Odd or Even?
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Concatenate including a date so that the date appears as a date | Excel Worksheet Functions | |||
date in Cell to change colors if the date is beyond today's date | Excel Discussion (Misc queries) | |||
Report Date - Date Recv = Days Late, but how to rid completed date | Excel Worksheet Functions | |||
copy date based on date -refer to date range | Excel Programming | |||
Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel |