Return Friday from last 3, 6 and 12 months

BigDelGooner

Board Regular
Joined
Aug 17, 2009
Messages
197
Hi all

I have a validated list that includes the last Friday of each week whereby a user can select their desired date. Based on the user selected date I want to lookup data for 3,6,12,36 and 60 month up to the date selected.

Not a problem for month ends but because this list has weekly data up to the last Friday of each week it is often random dates such as 25/03/11 and 01/04/11. How do I get the last Friday from 3,6,12 months ago etc. for one of these random dates?

Sure there is a simple answer but I am having a blackout at this moment in time so any help appreciated.
 

Some videos you may like

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

Desu Nota from Columbus

Well-known Member
Joined
Mar 17, 2011
Messages
556
I dont understand your question. What do you mean when you say the last friday of each week? There is only 1 friday in a week... right?

Are you trying to get data attached to Fridays in the past?

In chronological order?
In a list?
By searching for a certain date?

Please clarify what you need.
 

Asator

Board Regular
Joined
Apr 5, 2010
Messages
186
Friday, Friday, gettin down on Friday.

I don't understand the question either.
 

BigDelGooner

Board Regular
Joined
Aug 17, 2009
Messages
197
Sorry been away from my desk guys. Yes I meant the last Friday from either 3, 6 or 12 months previous to the date selected.

So if the user selected a date, say, Friday 01/04/2011 (i.e. 1st April using UK convention) then what formula would return the Friday from 3 months previous (i.e. 07/01/11).

Just for the record that Rebecca Black song has even made it over to the UK somehow!!!
 

Watch MrExcel Video

Forum statistics

Threads
1,109,033
Messages
5,526,371
Members
409,697
Latest member
christopherlewis1620

This Week's Hot Topics

Top