Add date with vba till date with add x number of days in excel

I want to add 182 days in fromdate till it reach todate and add 1 day in todate using VBA.

From Date	To Date
01/07/2017	31/03/2019
01/07/2017	30/12/2017
31/12/2017	01/07/2018
02/07/2018	31/12/2018
01/01/2019	31/03/2019

HTML Code: 

Any help would be greatly appreciated!
Thanks.

would this work?

Please Login or Register  to view this content.

Originally Posted by frabulator

would this work?

Please Login or Register  to view this content.

No,
i want to add date till 31-03-2019 (first row of to date column).

Said query raised on another platform : https://www.ozgrid.com/forum/index.php?thread/1229361