To-date total based on current date
: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.