Calculating The Last Tuesday Of Every Month

**lauzhang** · 07-05-2012, 05:44 AM

Hi,

I was just wandering if there's a way to calculate the last Tuesday of every month. I was looking online and probably being alittle dense. If you could point me in the right direction or possibly share a formula thankyou.

Sean

**daddylonglegs** · 07-05-2012, 06:07 AM

If you have today's date in A1 (or, indeed, any date) then you can get the last Tuesday of last month in A2 with this formula

=A1-DAY(A1)+1-WEEKDAY(A1-DAY(A1)+5)

If you copy that down then you'll get all the previous last Tuesdays in reverse order.

If you want the last Tuedays in the future then put this formula in A3 and copy down

=A2+35-7*(DAY(A2+35)<8)

**Bob Phillips** · 07-05-2012, 06:15 AM

Try this

=EOMONTH(A2,0)-WEEKDAY(EOMONTH(A2,0),2)+2

**Fotis1991** · 07-05-2012, 06:16 AM

With a date in A1, this will gines you the last Tuesday of this month.

=DATE(YEAR(A1),MONTH(A1)+1,0)+MOD(-WEEKDAY(DATE(YEAR(A1),MONTH(A1)+1,0),2)-2,-2)

**chakakhan8000** · 08-22-2017, 03:01 PM

That only gave me the last DAY of the month, not the last Tuesday.

**protonLeah** · 08-22-2017, 04:13 PM

chakakhan8000,
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.