kumara_faith
Well-known Member
- Joined
- Aug 19, 2006
- Messages
- 922
- Office Version
- 365
Hi,
I have a table as below:
I need to insert the monthly bonus of USD500 at the earliest date of the month and the yearly bonus of USD 2000 at the earliest date of the following year. I am working on a list of a few years. Is there a formula that I could use to automate this ? Appreciate all the help.
I have a table as below:
Book2 | ||||||||
---|---|---|---|---|---|---|---|---|
C | D | E | F | G | H | |||
2 | Date | Monthly Bonus | Yearly Bonus | Monthly Bonus | 500 | |||
3 | 14/1/2020 | 500 | Yearly Bonus | 2000 | ||||
4 | 15/1/2020 | |||||||
5 | 16/1/2020 | |||||||
6 | 17/1/2020 | |||||||
7 | 18/1/2020 | |||||||
8 | 19/1/2020 | |||||||
9 | 20/1/2020 | |||||||
10 | 21/1/2020 | |||||||
11 | 22/1/2020 | |||||||
12 | 23/1/2020 | |||||||
13 | 5/2/2020 | 500 | ||||||
14 | 6/2/2020 | |||||||
15 | 7/2/2020 | |||||||
16 | 8/2/2020 | |||||||
17 | 9/2/2020 | |||||||
18 | 10/2/2020 | |||||||
19 | 15/3/2020 | 500 | ||||||
20 | 16/3/2020 | |||||||
21 | 17/3/2020 | |||||||
22 | 18/3/2020 | |||||||
23 | 19/3/2020 | |||||||
24 | 20/3/2020 | |||||||
25 | 21/3/2020 | |||||||
26 | 4/1/2021 | 2000 | ||||||
27 | 5/1/2021 | |||||||
28 | 6/1/2021 | |||||||
29 | 7/1/2021 | |||||||
30 | 8/1/2021 | |||||||
Sheet1 |
I need to insert the monthly bonus of USD500 at the earliest date of the month and the yearly bonus of USD 2000 at the earliest date of the following year. I am working on a list of a few years. Is there a formula that I could use to automate this ? Appreciate all the help.