How to Protect Row If Date is Passed

Dear All

I have a sheet where there is date column and after that some data column
I tried so many things but I am unable to lock entire row if date is smaller than todays date
Please find attached sheet

I am not aware with any coding So Please give me sample sheet wher I can get the coding and format

User should be allow to enter or change data, if date in column is todays date
but he should not change the data or delete data or cell if date is smaler than todays date or
once the date is passed

give option for date is smaller than 2 days - todays date

Please help
PFA


Atul

Yes Champ

Thanks alot


Atul

Yes Sure

Your file wont allow to change date up to today or even cant delete the row. It is very good.
But I found it allows to change date for 29/07/2014 as 25/07/2014 at user can enter data in edited row

How to stop that
Help will be appriciable

Atul

Thanks for the solution

Just One thing I am not understanding
If date is containg 25, 26,28 and 29
In this case user can enter date 27 it will allow
because 27 is not available in previous data
Even If I want to insert rows for Todays Date then it should allow
to add rows for todays date not for previous or after
Even If I change system date then it allows to change data

Anyway you have given that is also usefull for me
If possible to restrict to enter old date and allow to insert new row for currant date
then please do.

Thanks

Please let me know is it possible to insert row for same date
and what about If I change system date. Now it allow to make changes
How can we restrict that?

You have rally helped me good
Atul

Waiting for your reply

Atul