Hello, I'm looking for date validation in excel.
I would to control the cell with given dates like the user can able to select or enter the date only two day prior and today's date. He should not select any other date like future date or two days prior date in the particular cell (say A1).
I can do validation using customs and today function....however if user can copy and paste the date from different cell to this cell then validation doesnot work at all....I must stop to user to copy and paste the date.
Kindly suggest some function or vba code to over come this issue.
Thanks
I would to control the cell with given dates like the user can able to select or enter the date only two day prior and today's date. He should not select any other date like future date or two days prior date in the particular cell (say A1).
I can do validation using customs and today function....however if user can copy and paste the date from different cell to this cell then validation doesnot work at all....I must stop to user to copy and paste the date.
Kindly suggest some function or vba code to over come this issue.
Thanks
