Automatically change a date to next quarter after the date has passed

[martin24]

Hi,

I am creating a table with a list of things to do every quarters of the year and was wondering if there is a way to automatically change the date to the next quarter after the posted date have passed. Example: I have to do task "A" every 3 months starting May 1st 2021. On May 2nd 2021 I would like the date to automatically change to August 1st 2021, on August 2nd 2021 I would like the date to keep changing another 3 months to November 1st 2021.... and so on, indefinitely. Task "B" would need to do the same but weekly. Task "C" monthly and lastly, task "D" Yearly.

Is it something that can be done?

This table would be stored on One Drive or something to be used with Microsoft Flow and send notification emails on the specified date.

Thanks for your help.

Martin

[Limor_OP]

Fast answers need clear examples. Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. Just before posting, scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.

[maniacb]

You can use something like this in the sheet module, for the 3 month change, assuming the task is in column A and the date is in column B

Please Login or Register  to view this content.

[GlennUK]

In your due date cell put this formula: =EOMONTH((TODAY()-1),2-MOD(MONTH(TODAY()-1)-2,3))+1