Delete cells with a formula not a macro

[Matt5353]

Hello.
This is my task.

Kenneth Wood

DV

23/05/2021

19/11/2021

Here

I wish to enter a formula in column 5 where it says "Here" so that it reads column 4 "19/11/2021". So that when today's date is added each day, the DV becomes *.
Tried numerous ways but I cannot get it to delete DV and replace it with *.
Andrew

 

[Jeffrey Mahoney]

You cannot have a formula change the contents of another cell. Why not add a formula in column 2 to show an asterisk if column 5 is today's date?

 

[Matt5353]

You cannot have a formula change the contents of another cell. Why not add a formula in column 2 to show an asterisk if column 5 is today's date?

It is more complicated than that. DV means double vaxed. Our passports last 6 months so when if the entry date is today's date then 6 months time I need to show that it has expired. Can I do conditional formatting in column 5 to show in column two a colour change? to yellow. I did try but I can get the date to show up yellow but not the DV.
Andrew

 

[Jeffrey Mahoney]

Yes, Highlight Both Cells B2 and D2 and enter a conditional formatting formula: =$D2<=EDATE(Today(),-6). Then choose the color you want to fill.