Re: 2nd and 4th Wednesdays formula?

Tech-Archive recommends: Speed Up your PC by fixing your registry

If your month is in cell C31 (4 for April as an example) then

=CHOOSE(WEEKDAY(DATE(2005,C31,1)),10,9,8,7,13,12,11)+DATE(2005,C31,1)

will return the date of the second Wednesday in that month; to get the
fourth Wednesday, just add 14 to each of the CHOOSE arguments
--
Gary's Student


"Bob Phillips" wrote:

> If you mean that you want every 14 days from a given Wednesday date, try
> this
>
> In A1, input your start date
> In A2, input =A1+14
> Then copy A2 down as far as you want to go.
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "lawdoggy" <lawdoggys3@xxxxxxxxxxx> wrote in message
> news:1123170452.363665.79330@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> > Hello,
> >
> > I need to figure out all the 2nd and 4th wednesdays for all year long.
> > These days are set and are used for the same purpose (training) so I
> > would like to be able to print a list instead of hunting down a
> > calendar and counting. Any help would be greatly appreciated!
> >
> > Thank you.....mitch
> >
>
>
>
.