Formula(s) to compute sums through last complete month
Posted by Dwight on June 08, 2001 5:06 AM
Column A represents dollar amounts received throughout an entire year. Column B represents dates associated with receipt of the dollars. I need to report month to date and year to date totals, both of which will run only through the last completed month. For instance, if $100 of revenue was received 1/15/01, $200 on 2/15/01, and $400 on 3/15/01 (assume this is current date), the year to date total in cell C1 would be $300 and the month to date total in cell D1 would be $200.
Any help would be appreciated.