Calculate the number of tuesdays in a month?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I calculate how many tuesdays are in a month?

For example if I have the date January 7, 2005 in A1?
I need to determine how many tuesdays are in that month so I can multiply
that
number by the mortgage payment due (IE. $333). (for a weekly payment).

Thanx.
 
With the date is in A1, =IF(MONTH(A1+35)=MONTH(A1),5,4), i.e. if 5 weeks from
the date is in the same month, there are 5 weeks, otherwise 4.
 
How do I calculate how many tuesdays are in a month?

For example if I have the date January 7, 2005 in A1?
I need to determine how many tuesdays are in that month so I can multiply
that
number by the mortgage payment due (IE. $333). (for a weekly payment).

Thanx.
Click to expand...


If your base date is a Tuesday, then Myrna's formula should work. But Jan 7,
2005 is not a Tuesday.

So if your base date is a random date in the month, then you have to figure out
the date of the first Tuesday, and then see if the fifth Tuesday is still in
the same month. That formula is a bit more complex:

=4+(MONTH(A1-DAY(A1)+36-WEEKDAY(A1-DAY(A1)+5))=MONTH(A1))


--ron
 
Back
Top