Re: 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" <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
>


.

Relevant Pages

  • Re: 2nd and 4th Wednesdays formula?
    ... > would like to be able to print a list instead of hunting down a ... > calendar and counting. ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: 2nd and 4th Wednesdays formula?
    ... >would like to be able to print a list instead of hunting down a ... >calendar and counting. ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: How to calculate date and time
    ... >>i want to subtract the two cells ... > The latter would be correct if you were counting full calendar months (February ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • Re: 2nd and 4th Wednesdays formula?
    ... Tim C ... > calendar and counting. ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Why do different countries start the week on different days?
    ... It's simple to understand why humans developed base-10 counting all ... It's sensible that some other cultures would have counted larger time ... days, plus one day which is outside the calendar, such as April Fool's ... based on the sun, with 365 days a year, and the lunar religipus ...
    (alt.usage.english)