Return Friday from last 3, 6 and 12 months

[BigDelGooner]

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.

 

[Desu Nota from Columbus]

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]

Friday, Friday, gettin down on Friday.

I don't understand the question either.

 

[Dryver14]

do you mean the last Friday of each Month?

 

[Desu Nota from Columbus]

I actually laughed out loud (aka lol'd) at the Rebecca Black comment and startled co-workers.

 

[BigDelGooner]

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!!!