D
DF
Is there a way to find the second Wednesday of each month using Excel
97?
97?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Peo Sjoblom
Try
=DATE(YEAR(A1),MONTH(A1),15)-WEEKDAY(DATE(YEAR(A1),MONTH(A1),4))
where A1 holds any day of the particular month you want to check for
=DATE(YEAR(A1),MONTH(A1),15)-WEEKDAY(DATE(YEAR(A1),MONTH(A1),4))
where A1 holds any day of the particular month you want to check for
T
Teethless mama
=11-WEEKDAY(DATE(YEAR(TODAY()),MONTH(TODAY()),1))+DATE(YEAR(TODAY()),MONTH(TODAY()),1)
R
Ron Rosenfeld
Is there a way to find the second Wednesday of each month using Excel
97?
With some date in the month of concern in A1, try:
=A1-DAY(A1)+15-WEEKDAY(A1-DAY(A1)+4)
--ron
D
DF
DF said:Is there a way to find the second Wednesday of each month using Excel
97?
Hey, it works!!
I tried the formulas given by Peo Sjoblom and Ron Rosenfeld and both work
equally as well. The third formula given by whomever, works but only for
the current month. Thanks for your help. This is neat.
R
Ron Rosenfeld
Hey, it works!!
I tried the formulas given by Peo Sjoblom and Ron Rosenfeld and both work
equally as well. The third formula given by whomever, works but only for
the current month. Thanks for your help. This is neat.
Glad to help. Thanks for the feedback.
--ron
D
David Biddulph
Hey, it works!!
I tried the formulas given by Peo Sjoblom and Ron Rosenfeld and both work
equally as well. The third formula given by whomever, works but only for
the current month. Thanks for your help. This is neat.
Did you try replacing TODAY() in that third formula by A1?
D
DF
"David Biddulph" <groups said:Did you try replacing TODAY() in that third formula by A1?
No, but I'm sure that would work. I now have two formulas that do what I
want so I didn't bother to try that.