|You can't have a value in a cell and a formula that works on that value in the same cell. Think about it...how would that work?|
Once you added 4 to the value your formula would want to add 4 again and then add 4 again and then add 4 again, etc.
I can think of 2 options to get it done in the same cells as the dates:
1 - Enter 4 in an empty cell
2 - Right click...Copy
3 - Select your dates
4 - Right-click...Edit...Paste Special...Add
5 - You might have to reformat the cells as Date if they turn into date-serial numbers.
Change the Range in this macro to match your Range and run it.
For Each myDate In Range("B7:B22")
myDate.Value = myDate.Value + 4
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.