function to sum based on date

Looking to be able to change the date and the function will automatically sum the columns to give me the total year to date.

In the attached file I would like to change the date highlighted in blue and it will sum the columns from Jan07 to the date entered.


Any help appreciated.

Thanks
John