Hello,
I have attached one validation file where i am entering data month wise.
I have added a data validation so that user can enter current month data only. I added data validation formula like "=MONTH(TODAY())=7". I want 15 days grace in this so that user can enter data till 15th of next month.
I also added conditional formatting like "=MONTH(TODAY())<>7", color gray, so that all other month except current month turns to gray. Here also need 15 days grace.
Please help me on this.
Bookmarks