Good day everyone. This forum has become invaluable in my education of Excel. I now have a question I don't know the answer to.
I am trying to create a spreadsheet that adds up a progressive total of tasks done compared to what should be done by that date. For example if today is January 3rd I want the "should be done" total to be a cumulative total of Jan 1, 2 and 3. However, I don't want it to add up the information for the rest of the year in the succeeding cells. Basically I want it to automatically update the formula to cumulate the total based on what the date is.
I have attached a PDF that illustrates what I am looking to do. This is a sample and my actual file has the dates filled to the end of the year.
All help would be most appreciated.
Thank you
Shane
Bookmarks