I am not able to think properly to resolve this issue. You see, I have a point on the map of an event that needs to stay there for a period of 15 days and I would like to know how on the 16th day it would be deleted automatically. Follows details of the spreadsheet. Thankful.
You must use a script to check for the value and delete them, run them everyday at midnight, probably.
If it doesn’t necessarily need to be deleted, you could also just set a filter to exclude dates prior to Today. It will still use up rows, but wouldn’t require a script.