Returning a previous date & value based on the current date

Giganews Newsgroups
Subject: Returning a previous date & value based on the current date
Posted by:  Hawkster (neil.perei…@nz.teletech.com)
Date: 23 Jan 2007

Hello,

Sorry not sure if the subject describes clearly what i am after.

I have a report which is setup as follows (with data going back a few
years):

Week Beginning      Value
18/12/06                    43
25/12/06                    25
1/1/07                        9
8/1/07                      36
15/1/07                    98

I am after a formula that will return the date and value that is 52
weeks back from the current date.

This report will constantly be growing so it would need to be a rolling
formula.

Any help would be appreciated.

Neil

Replies