dreamkeeper Posts: 1, Reputation: 1 New Member #1 Aug 9, 2006, 09:07 AM
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?

 ScottGem Posts: 64,966, Reputation: 6056 Computer Expert and Renaissance Man #2 Aug 9, 2006, 10:16 AM
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.

 Question Tools Search this Question Search this Question: Advanced Search

## Check out some similar questions!

Total current assets [ 5 Answers ]

How do you compute 1. Current assets. 2. Long-term assets. 3. Current liabilities. 4. Long-term liabilities. 5. Stockholders' equity. In my balance shee I have four entries. Land, Cash, Building, Accounts payable, Notes Payable (short terms) and equipment, capital stock, retained...

When is the right age to date [ 21 Answers ]

Just curious. When do u guys think is the right age to start dating?:confused:

Too soon to date? [ 10 Answers ]

heyy everyone, I just got out of a two year relationship last month. It was a downhill relationship after the first year and a half I knew he had changed his mind on wanting to be with me and get married. We had marriage plans, I was very close to his family and spent every day for the past 2...

How do I ask her on a date? [ 3 Answers ]

I have a question on how I can ask this girl on a date. There is this girl in my youth ministry group (church thing) that I have a huge crush on. She hasn't gone there in awhile, but I found that she works at a mexican restaurant. So of course it becomes my favorite place to eat. That is the only...

As I mention before, I changed from F-1 to H-1 last year. I got my H-1 status in Feb 2004, but I went to my home country to get the H-1 visa stamp in August 2004. So I would like to know for counting my H-1 status, is it the date that USCIS (the Immigration) approved (which is Feb 1st), or the...