I have 300 stores with each having different reset days. I imported an excel file so i can have the store number and corresponding reset date as an field.
I am trying to calculate total sales since the store was reset.
I have a field called [Reset Date] which is the list of all stores with their corresponding reset date.
for example: store 9999 was reset on 1/31/2011, today is 3/1/2011, my goal is to calculate the total sales between 1/31/2011-3/1/2011.
This is the formula i am using to calculate how many days its been since the store is reset.
= (Today()-'1/1/2011') - Date(([Reset Date]-'1/1/2011')-1,"dd,mm,yyyy") , and it works
