Hi guys,

I need some help with an array formula,

In the attached spreadsheet I have sumed up column B $ Value for all dates that fall in September,

I was wondering if I can use a similar formula to look at t forecast, i need to move all the dates on by 1 month and then total all the $ values that occur 1 month later (ie during the month of October)

I have tried putting an EDATE formula into the array to see if this moves all dates on my 1 month but it returns an error

I was wondering if there is a formula to do this instead of me having to create a new column and move the dates on manually.

This needs to be repeated several times

Thanks
example.xlsx