Excel nesting If statement with multiple dates - formula help!

[cddny]

Hello. I am hoping someone can help me write a formula. I am trying to automatically fill in a specific date based on certain criteria. Here's what I have so far:

=IF(V4>21,"[D4+7]",IF(V4>14,"[D4+5]",IF(V4>7,"[D4+2]","EnterDate")))

V4=# of days between the start and end dates
D4=the start date

So based on this IF nesting formula, I would want a specific date to populate and not "[D4+7]", for example if V4=25.

I know the " " is causing the answer to basically copy whatever text is in between the " " but I want it to populate a date.

In this example, if D4=11/1/24 AND V4=25, then I would want the answer to be 11/8/24. I am asking how I can convert "[D4+7]" to 11/8/24.

I hope that makes sense. Thank you for your help.