Re: 2nd and 4th Wednesdays formula?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

On 4 Aug 2005 08:46:42 -0700, "lawdoggy" <lawdoggys3@xxxxxxxxxxx> wrote:

>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

With any date of a month in A1:

2nd Wednesday:

=A1-DAY(A1)+15-WEEKDAY(A1-DAY(A1)+4)

4th Wednesday:

=A1-DAY(A1)+29-WEEKDAY(A1-DAY(A1)+4)


--ron
.

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)