Is there a way to set an equation so it will look for its date ranges from another cell??
I have attached a sample sheet.
In Column E Row 2 I would like to have an equation that would say something like the following:
And have the dates change based on Cell B2 and D2.
So if I change B2 to 5-31 it would change the date in the equation to:
I also recognize that my SUMIFS equation is not exactly right. May need a little help with it as well. :-)
Does this make sense??