Is it possible to use EOMONTH as a test criteria in a sumproduct array?

I have the EOMONTH set up as column headers on my worksheet to show a 7
month window of data (3 months prior, current month, and 3 months future),
this will always be current based on the current date. I want to pull data
from a separate work sheet based on monthly totals, but I would like to
incorporate the EOMONTH formula into the sumproduct so the data stays current
with the column headers.