LinkBack URL
About LinkBacks
Hi,
Can anyone help me with how to build the forumla or VBA to get a certain day of the week that past say three weeks ago? I need to be able to edit it to get the different days and weeks.
Thanks for your time.
Formula to get Monday/Friday of x weeks ago
Hi,
Can anyone help me with how to build the forumla or VBA to get a certain day of the week that past say three weeks ago? I need to be able to edit it to get the different days and weeks.
Thanks for your time.
You mean something like this?
http://www.wikihow.com/Calculate-the...-Week-in-Excel
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.
Cheers for the quick reply, although I'm just wanting to get the date of Monday/Friday say three weeks ago...
...i think this forumula gives me Friday two weeks ago: =(TODAY()-WEEKDAY(TODAY()+2,2))-7 - but im wanting to be able to edit this so I can do whatever days or weeks ago I want
Get me or not?
hi there. different interpretation. say A1 contains the formula
=TODAY()
then:
=A1-WEEKDAY(A1,2)-3*7+1
the red one is where you put your weeks & the blue one is the day of the week (1 is Mon, 5 is Fri)
you can also replace all A1 with TODAY(), and also change the coloured ones to a cell reference to input
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Thanks very much mate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks