Hello,
I'm new to Excel so please forgive me if I don't make sense.
I'm trying to show if a date is between a and b it shows c but if it's between d and e it shows f and so on. E.g. if between the start and end date then fees are due the 14th of the middle month of the next quarter.
I need to show
Thank you in advance!
I'm new to Excel so please forgive me if I don't make sense.
I'm trying to show if a date is between a and b it shows c but if it's between d and e it shows f and so on. E.g. if between the start and end date then fees are due the 14th of the middle month of the next quarter.
I need to show
Quarter Start | Quarter End | Quarter Due |
01/01/2022 | 31/03/2022 | 14/05/2022 |
01/04/2022 | 30/06/2022 | 14/08/2022 |
01/07/2022 | 30/09/2022 | 14/11/2022 |
01/10/2022 | 31/12/2022 | 14/02/2023 |
Thank you in advance!
Last edited by a moderator: