Finding Particular Day of Month

  • Thread starter Thread starter DF
  • Start date Start date
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
 
=11-WEEKDAY(DATE(YEAR(TODAY()),MONTH(TODAY()),1))+DATE(YEAR(TODAY()),MONTH(TODAY()),1)
 
Is there a way to find the second Wednesday of each month using Excel
97?
Click to expand...

With some date in the month of concern in A1, try:

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


--ron
 
DF said:
Is there a way to find the second Wednesday of each month using Excel
97?
Click to expand...


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.
 
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.
Click to expand...

Glad to help. Thanks for the feedback.
--ron
 
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.
Click to expand...

Did you try replacing TODAY() in that third formula by A1?
 
"David Biddulph" <groups said:
Did you try replacing TODAY() in that third formula by A1?
Click to expand...

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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

count wednesdays within a month 7
Count Wednesdays within a calendar month 1
Countif Function?? 3
Number of Specific Day within Dates 5
how to check for days of the week 7
Excel Monthly Spread sheet. 12
Return the first Wednesday of each month 4
Calendar, if paid on date, not count prior 2

Back
Top