Jim, You can use (ADDDAY(.datethisyear, (-1 * 52 * 7))
It works over a leap day, too. Bill On Mon, May 10, 2010 at 5:22 PM, Jim Belisle <[email protected]> wrote: > I want to compare weekly totals one year apart. > > But I want to make sure the comparison is 52 weeks ago. > > In other words, I want to compare Sun – Sat this year with Sun – Sat 52 > weeks ago. > > > > Right now I am using the two dates this year – 365 days for each date. > > > > Jim > > >
