2nd and 4th Wednesdays formula?

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" <[email protected]> wrote in message
news:[email protected]...
> 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
>

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" <[email protected]> wrote in message
> news:[email protected]...
> > 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
> >
>
>
>

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

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" <[email protected]> wrote in message
news:[email protected]...
> 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
>

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" <[email protected]> wrote in message
> news:[email protected]...
> > 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
> >
>
>
>