Ask Experts Questions for FREE Help !
Ask
    dreamkeeper's Avatar
    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?


    Thanks for your help.
    ScottGem's Avatar
    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.

Not your question? Ask your question View similar questions

 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


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

F-1 to H-1, what's the start date of H-1? Should be approval date or visa issue day? [ 3 Answers ]

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


View more questions Search