Hi Experts

Is it possible to set condition in excel on dates using VBA in which a user can update the dates say from today “10/02/2015” in a cell and he/she can update the same cell till next 7 days. After the 7th day excel either won’t allow the user to change the date or change the color of the cell if someone tries to change the date.

Regards,
Jagdev