Hello everyone,

Im trying to find a way to SUM depending on today's date it will choose wich cell to sum plus the next 5 cells. Lets say:

I have a forecast where Im suppose to have available the material for the next 6 monts, so if today is 1/jan/14 I should have in inventory all the materials required from 1/jan until 30/jun.

This is more or less what I have:

Oct-13 Nov-13 Dec-13 Jan-14 Feb-14 Mar-14 Apr-14 May-14 Jun-14 Jul-14 Aug-14 Sep-14
1 1 0 1 1 0 1 1 0 1 1 0

I need a function that tells me how much materials should I have depending on today's date. Is there a way to do it? Thanks a lot!!