I need to be able to track data on a rolling 12 month cycle. For instance,
how much money has been brought in from exactly 1 year ago from todays date?,
Tomorrow, same question. My date is in Column B and the data that needs added
together is in Column G. If the date in Column B is within the last 364 days
from the current date I need the numbers in the corresponding Column G to add
together and give me a sum at a glance. Can anyone tell me if this is
possible and how to write the formula to get the info that I need?
Thanks