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
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
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)
Audere est facere
Try this
=EOMONTH(A2,0)-WEEKDAY(EOMONTH(A2,0),2)+2
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)
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
That only gave me the last DAY of the month, not the last Tuesday.
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.
Ben Van Johnson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks