Hello - excel experts, I'm hoping you can help me. On a quarterly basis I do a pivot table from files I combine to monitor and forecast assignments (dates change frequently and there are new vendors added and removed). I manually add an "x" into the quarters where a vendor is "active" (the quarter is between the start and end date). I should be able to set an IF statement to populate this , but haven't been able to figure this out. Can anyone help? I've included a simple sample to demonstrate what I want to fill.

I've just made a linked connection to my sharepoint list so data is automatically updated to make this less burdensome, so if I can figure out a wat to fill the forecasting, this will save me time.

Appreciate the help!

Attached Files

Example data.xlsx (20.7 KB, 9 views)