How to make add cells together after a partic

Closed
Report
Posts
1
Registration date
Wednesday August 18, 2010
Status
Member
Last seen
August 18, 2010
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

I am setting up a checkbook ledger in Excel. I am trying to figure out how to make a cell add after the first day of the month.

The D2-J2 cells will add the amounts in from the cells below.
The C1 cell is the total of the D2-J2.
What I am wanting to do is make C1 add up D2-J2 only after the current date falls past the first of the month for each column.
Basically C1 will have the amount of D2 in it until Feb 1st. Then C1 will have the amount in it of D2 and E2. Then after march 1st C1 will have the amount in it of D2-F2. So on so on.

Also in the formula that does this is there a way to not make it year specific. I am wanting to save this as a template and use it for quite some time. I am very new to this. I have only been working with excel for a few months now. Thanks in advance.

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc
A N D post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too
0