Automatically delete rows after time period using time stamp (have partial code)

Cross-posted at https://www.mrexcel.com/board/thread...-code.1219627/ --6SJ

I am looking to apply a timestamp, and automatically delete the row when it is 4 years old. I can make it work to automatically delete the row within a 24 time period, but I cannot set larger periods or I am presented with a type mismatch.
This is the code I was using

Please Login or Register  to view this content.

I identified the issue was quantifying it as time value so attempted to change it to the following:
If Now > stampcell.Value2 + DateAdd("d", 1, stampcell.Value2) Then

This was so I could test it before changing it to 6 years.

Is there anyway for me to do this?

Hi there,

This will check for 4 years:

Formula:

Please Login or Register  to view this content.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important: https://excelguru.ca/a-message-to-forum-cross-posters/

You now have people duplicating effort by providing answers in both places. That is why we (and also the other forum) require you to provide a link if you ask the same question in other places.

I have added the link to your post since it's your first thread.

Originally Posted by LeoSkywalker

This will check for 4 years:

Take leap year into account:

Please Login or Register  to view this content.