populate date in first cell based on previous cell plus 30 days

[leap out]

Hello
I want search for the containing in last cell in column B and copy & put in next cell in column A and add 30 days for cells in last cell in column A when show date in adjacent cell in column B without red color , copy to next cells just based on one condition when the date in last cell in column B is matched with date(today) in PC , then should copy to next cells in columns A,B
I want to do that when open workbook automatically .
original

DATE.xlsm
	A	B	C	D
1	FROM	TO	DE	VL
2	28/07/2023	27/08/2023
3	27/08/2023	26/09/2023
sh

should be

DATE.xlsm
	A	B	C	D
1	FROM	TO	DE	VL
2	28/07/2023	27/08/2023
3	27/08/2023	26/09/2023
4	26/09/2023	26/10/2023
sh

thanks

 

[leap out]

perfect !
this is what I want it.
thank you so much .

 

[duggie33]

Glad to help.

Doug