G
Guest
I want to total the amounts between certain dates. I have a list of dates
that each bill is due, the 1st, the 9th, the 12th, the 18, the 20th etc......
A has the Date, B has the bill, C has the amount. E has been filled with
dates 2 weeks apart, this is when we pay bills. I want Excel to look at the
date in E and have it compare it to the bill dates in A, and total the amount
that needs to be paid during that cycle. For example, if we pay on the 2nd
and then again on the 16th, I want to know the total of what is due between
the 2nd and the 16th.
that each bill is due, the 1st, the 9th, the 12th, the 18, the 20th etc......
A has the Date, B has the bill, C has the amount. E has been filled with
dates 2 weeks apart, this is when we pay bills. I want Excel to look at the
date in E and have it compare it to the bill dates in A, and total the amount
that needs to be paid during that cycle. For example, if we pay on the 2nd
and then again on the 16th, I want to know the total of what is due between
the 2nd and the 16th.