So it's going to keep inserting dates... if the file has been opened 22 times, there will be 22 dates inserted? .

"promts me to enter how many days from today I wish to show"... Prompts you? How many days to show? In your original post, you wanted to calculate and insert a date 7 days in the future. Now it seems you want to be prompted for the number of days and use that date to control the display of something.

What exactly are you trying to do?