Hi all,
I have a number of rent dates and need to round them up to the next quarter. However, I would like to be able to alter the start date so that the dates are rounded to the next 3 month quarterly period (not necessarily the same as the proper Quarter dates)
So, I am looking for a fomula to put in C1 that rounds the date in B1 (by way of example "05/02/15") up to the next quarter date. But I do not mean quarter as in March, June, Sept, Dec. Instead, if the start date is "31/1/15" (in Cell A1) then the next quarters would become 30/04/15, 30/07/15, 30/10/15. Therefore the formular should return "30/04/15" in cell C1.
Does anyone have a formula?
Thanks
I have a number of rent dates and need to round them up to the next quarter. However, I would like to be able to alter the start date so that the dates are rounded to the next 3 month quarterly period (not necessarily the same as the proper Quarter dates)
So, I am looking for a fomula to put in C1 that rounds the date in B1 (by way of example "05/02/15") up to the next quarter date. But I do not mean quarter as in March, June, Sept, Dec. Instead, if the start date is "31/1/15" (in Cell A1) then the next quarters would become 30/04/15, 30/07/15, 30/10/15. Therefore the formular should return "30/04/15" in cell C1.
Does anyone have a formula?
Thanks