heretolearnexcel
Board Regular
- Joined
- Jan 22, 2019
- Messages
- 58
- Office Version
- 365
- Platform
- Windows
Hi,
I have a Table with days like this:
I need a formula that if x number of days have passed it will do something. For example, if 5 days have passed since last time, "sum these two values"
column A= C+D, if 5 days have passed since last time there was a value in the column:
<tbody>
</tbody>
Any ideas on how to achieve this?
Thanks.
I have a Table with days like this:
I need a formula that if x number of days have passed it will do something. For example, if 5 days have passed since last time, "sum these two values"
column A= C+D, if 5 days have passed since last time there was a value in the column:
1 | DATE | Days passed | A | C | D |
2 | 1-Jan | 19 | 10 | 9 | |
3 | 2-Jan | 1 | 14 | 15 | |
4 | 3-Jan | 2 | 5 | 10 | |
5 | 4-Jan | 3 | 11 | 5 | |
6 | 5-Jan | 4 | 19 | 12 | |
7 | 6-Jan | 5 | 26 | 12 | 14 |
8 | 7-Jan | 1 | 14 | 7 | |
9 | 8-Jan | 2 | 17 | 11 | |
10 | 9-Jan | 3 | 17 | 1 | |
11 | 10-Jan | 4 | 6 | 3 | |
12 | 11-Jan | 5 | 16 | 3 | 13 |
13 | 12-Jan | 1 | 1 | 19 | |
14 | 13-Jan | 2 | 18 | 1 | |
15 | 14-Jan | 3 | 18 | 15 |
<tbody>
</tbody>
Any ideas on how to achieve this?
Thanks.
Last edited: