I am doing a personal budget and wanted I40 and I41 to add together if the 25th of the month fell on a Saturday.
<tbody>
</tbody>
Below you can see on the 25th of the month (Saturday) the $445 took (I27) but not adding in the $150 (below that is the formula held in I27). Not sure what I am missing.
<tbody>
</tbody>
<tbody>
</tbody>
<tbody>
</tbody>
H | I | J | |
---|---|---|---|
40 | Car | $445 | 25 |
41 | Groceries/Gas | $150 | Saturday |
<tbody>
</tbody>
G | H | I | J | |
---|---|---|---|---|
2 | Money Out | Money In | ||
3 | 1 | Wednesday | $ - | |
4 | 2 | Thursday | 0 | |
5 | 3 | Friday | 0 | |
6 | 4 | Saturday | $ 150 | |
7 | 5 | Sunday | $ - | |
8 | 6 | Monday | 0 | |
9 | 7 | Tuesday | 0 | |
10 | 8 | Wednesday | 0 | |
11 | 9 | Thursday | $ - | |
12 | 10 | Friday | 0 | |
13 | 11 | Saturday | $ 150 | |
14 | 12 | Sunday | 0 | |
15 | 13 | Monday | 0 | |
16 | 14 | Tuesday | 0 | |
17 | 15 | Wednesday | $ - | |
18 | 16 | Thursday | 0 | |
19 | 17 | Friday | 0 | |
20 | 18 | Saturday | $ 150 | |
21 | 19 | Sunday | 0 | |
22 | 20 | Monday | 0 | |
23 | 21 | Tuesday | 0 | |
24 | 22 | Wednesday | 0 | |
25 | 23 | Thursday | 0 | |
26 | 24 | Friday | 0 | |
27 | 25 | Saturday | $ 445 | |
28 | 26 | Sunday | 0 | |
29 | 27 | Monday | 0 | |
30 | 28 | Tuesday | 0 | |
31 | 29 | Wednesday | 0 | |
32 | 30 | Thursday | $ - | |
33 | 31 | Friday | 0 | |
34 | ||||
35 | ||||
36 | Expenses | Day of the Month | ||
37 | Cell Phone | $0 | 5 | |
38 | KCPL | $0 | 9 | |
39 | Mortgage/Insurance | $0 | 15 | |
40 | Car | $445 | 25 | |
41 | Groceries/Gas | $150 | Saturday |
<tbody>
</tbody>
2018
I | |
---|---|
27 | $ 445 |
<tbody>
</tbody>
2018
Worksheet Formulas
<tbody> </tbody> |
<tbody>
</tbody>