Sum depending on today's date.

[jnh0]

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!!

[ramananhrm]

Please try this file.

[sktneer]

If you put the criteria date in A4 (which is 1/jan/2014 in your case), place the formula below in the cell B4 or in the cell of your choice.

Please Login or Register  to view this content.

Please find the attached sheet.