| Book1 | |||||||
|---|---|---|---|---|---|---|---|
| A | B | C | D | E | |||
| 1 | start date (given) | July 1 of same year | July 1 of following year | April 1 of following year | April 1 of year + 2 | ||
| 2 | 12/1/2020 | 7/1/2020 | 7/1/2021 | 4/1/2021 | 4/1/2022 | ||
| 3 | 3/22/2021 | 7/1/2021 | 7/1/2022 | 4/1/2022 | 4/1/2023 | ||
| 4 | 5/17/2021 | 7/1/2021 | 7/1/2022 | 4/1/2022 | 4/1/2023 | ||
| 5 | 6/7/2021 | 7/1/2021 | 7/1/2022 | 4/1/2022 | 4/1/2023 | ||
| 6 | 10/25/2021 | 7/1/2022 | 4/1/2022 | 4/1/2023 | |||
| 7 | 11/1/2021 | 7/1/2022 | 4/1/2022 | 4/1/2023 | |||
| 8 | 12/20/2021 | 7/1/2022 | 4/1/2022 | 4/1/2023 | |||
| 9 | 1/4/2022 | 7/1/2022 | 7/1/2023 | 4/1/2023 | 4/1/2024 | ||
Sheet1 | |||||||
| +Fluff 1.xlsm | |||||||
|---|---|---|---|---|---|---|---|
| A | B | C | D | E | |||
| 1 | start date (given) | July 1 of same year | July 1 of following year | April 1 of following year | April 1 of year + 2 | ||
| 2 | 01/12/2020 | 01/07/2021 | 01/04/2021 | 01/04/2022 | |||
| 3 | 22/03/2021 | 01/07/2021 | 01/07/2022 | 01/04/2022 | 01/04/2023 | ||
| 4 | 17/05/2021 | 01/07/2021 | 01/07/2022 | 01/04/2022 | 01/04/2023 | ||
| 5 | 07/06/2021 | 01/07/2021 | 01/07/2022 | 01/04/2022 | 01/04/2023 | ||
| 6 | 25/10/2021 | 01/07/2022 | 01/04/2022 | 01/04/2023 | |||
| 7 | 01/11/2021 | 01/07/2022 | 01/04/2022 | 01/04/2023 | |||
| 8 | 20/12/2021 | 01/07/2022 | 01/04/2022 | 01/04/2023 | |||
| 9 | 04/01/2022 | 01/07/2022 | 01/07/2023 | 01/04/2023 | 01/04/2024 | ||
Data | |||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| B2:B9 | B2 | =IF(MONTH(A2)>7,"",DATE(YEAR(A2),7,1)) |
| C2:C9 | C2 | =DATE(YEAR(A2)+1,7,1) |
| D2:D9 | D2 | =DATE(YEAR(A2)+1,4,1) |
| E2:E9 | E2 | =DATE(YEAR(A2)+2,4,1) |
I want to use the start date (which I indicated as "given") and insert formulas into other fields as appropriate to the task to give me any of the other four columns. I would apply the appropriate formula as needed to schedule performance reviews. So if someone started on March 1 in some cases their next annual review would be in July of the same year, in others in April of the next year. I can make those determinations, I just need the four formulas to do the math for me to save me time.
Let me plug that in and see if it works. Thank you!
They each need to reference a starter cell. The entries were just for examples of the results we're looking for.
