Hey guys, I am creating an Excel workbook for keeping track of my bills. I have it all set except for one formula that is still giving me problems and I am looking for some asistance. In rows E4 - E21 I have dates entered for when the bill is due. In rows G4 - G21 I have the respective amount due for the bill. Now in cell B26 I have a formula that takes the sum of the G4 - G21 to give me the total for my months bills. The piece I want to add to this last formula however is for it first to check to see if the due date is in the same month as the current month. If the month entered is say for the next month, then I want it to subtract that months dues from my total monthly due. On a same note, if that is not already too much. I would like to add a functionality for a cell (Specifically row rows E4 - E21 with the dates) to automatically adjust the time to the following month, maintaining the same day, when the specific day entered in the cell has arrived. The reasoning for this is when an auto pay bill reaches the pay day, it automatically adjust itself for being paid, and jumps to the next due date. Hopefully that makes sense. I have looked around with the VLOOKUP but have not found something similar to this to create it on my own. Thanks for any input.. Bobby

Heavy, you need a monthcode(yes or no to sum) and a trigger to autoupdate this monthcode: make a column with: "=IF(C4="auto";IF(D4<=NOW();MONTH(NOW())+1;MONTH(NOW()));MONTH(D4))". Where C4 has "auto" or not, D4 has your date. This gives you the due montnumber. Then use sumif: "=SUMIF($E$4:$E$8;MONTH(H$1);$F$4:$F$8)". Where H1 has the month which you want. Here I suggest two more columns for one month before and one later. H1 has: "=DATE(YEAR(NOW());MONTH(NOW());1)" G1 has "=DATE(YEAR(NOW());MONTH(NOW())-1;1)". Ofcourse yearends will give you other troubles Have a nice day Joost

Joost, I am glad you were able to post a response to this very deep query were I could not. Thanks and regards, Bryan