current month to date?

  • Thread starter Thread starter Barry V.
  • Start date Start date
B

Barry V.

How do I create a running total of numbers for the current
month to date and then have that formula start over
automatically when the month changes? The user only wants
to see that one number.
 
You can use a formula to calculate the running total, and apply
conditional formatting to hide the numbers:

If the dates start in A2, and the amounts start in B2:

1. In cell C2, enter the formula: =B2
2, In cell C3, enter the formula: =IF(MONTH(A3)=MONTH(A2),C2+B3,B3)
and copy down to the last row of data
3. Select column C, and format with White font colour.
4. Select column C, and choose Format>Conditional Formatting
5. From the first dropdown, choose Formula Is
6. In the text box, type: =MONTH(A1)<>MONTH(A2)
7. Click Format, and choose Black font colour.
8. Click OK, click OK

Only the monthly subtotals will appear in black font.
 
Back
Top