2nd and 4th Wednesdays formula?
 

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" wrote in message
ups.com...
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,1 1)+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" wrote in message
ups.com...
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