I am trying to create a formula that will look up sales. I would like it to be Saturday to Saturday and here is the problem. Jan 1 2010 was a Friday, were Jan 1 2011 is a Saturday. How do I create a formula that looks up and matchs Jan1 2011 Saturday to Jan 2 2010 Saturday and then displays the sales data?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Sales lookup comparing day to day
- Thread starter Korimint
- Start date
Similar threads
- Question
