anish201
07-19-2005, 05:51 PM
:dunno How do I declare a module wide date that is in the form of say (3rd wednesday of the month every Mar, June, Sep, Dec). This should be going forward to any number of years.
I want help with some code or ideas as to how I can write code which tells Excel that when I wrtie a date say Mar 23 or July 6 to check that, that date that is in the form of say (3rd wednesday of the month every Mar, June, Sep, Dec).
Like I want this code to list a column of sales, but if the sales fall after the 3rd wednesday of Mar, June, Sep or Dec I want Excel to do something else. For eg: if today is the second wednesday of mar then excel doesnt do anything but if it is the 3rd thursday then i want it to check for that date and see that it has passed the 3rd wed of march and hence now it should act in a certain way or produce a certain result.
I want help with some code or ideas as to how I can write code which tells Excel that when I wrtie a date say Mar 23 or July 6 to check that, that date that is in the form of say (3rd wednesday of the month every Mar, June, Sep, Dec).
Like I want this code to list a column of sales, but if the sales fall after the 3rd wednesday of Mar, June, Sep or Dec I want Excel to do something else. For eg: if today is the second wednesday of mar then excel doesnt do anything but if it is the 3rd thursday then i want it to check for that date and see that it has passed the 3rd wed of march and hence now it should act in a certain way or produce a certain result.