:confused: I am trying to create a forumula that will give a cumulative or
"to-date" total that will exclude future months from the total.

i.e. ithe point in time is August and I need to show a to-date number
Through August only even though September and October are included in
The spreadsheet. Next month will need to show through September and
Exclude October.


Columns: July August September October year-to-date
Rows : 100 200 300 400
Year-to-date as of August should show 300 if the point in time is
August and show 600 if it's September


Is there a way to write a formula using time or that will change based
On the current date?


Thanks for your help.

Its possible. You would need to dynamically calcluate the range of columns based on the month number. I'm not sure of the exact formula. It would take some time to play with it.