LinkBack URL
About LinkBacks
How to prevent input certain date and holiday.
How to prevent input certain date?
How to prevent input certain date and holiday.
Hi there,
Either you can create a list of dates which are supposed to be entered or can use some simple formula with DV to prevent input holiday and other dates.
Also, request you to please attach a sample workbook in order to give more clarity on your requirement.
Thanks,
Anil Dhawan
dates: on March 2016: 6, 11, 12, 13, 17, 20, 27
Hi,
First make a list of date you want to exclude, in a separate column say column J (J1:J7)
Suppose your cell is I1 where you want to enter dates.
Go to Data > Data Validation > Custom > =$I$1<>$J$1:$J$7 > Hit OK
Regards,
Khalid
Khalidngo, how to prevent input on many cells? ex: $I$1:$I$100
Hi,
You can use following formula in "CUSTOME" under Data Validation in order to prevent specific dates.
Please Login or Register to view this content.
Just select the range before putting Data Validation and the entire selected range will prevent users from entering specific dates..Originally Posted by putritersenyum
Thanks,
Anil Dhawan
Click *Add Reputation to say "Thanks" and don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved) if you are satisfied.
Don't stop when you are tired. STOP when you are done!
May be this:
Select your range I1:I100
Data Validation > Custom:
=NOT(COUNTIF($J$1:$J$7,I1)>0)
Regards,
Adhawan06 and Khalidngo thankyou very much all of your formulas work for me... and I can use your formulas.
Thank you for your kind feedback..
Please take few seconds to mark this thread as SOLVED and *Add Reputation to the user(s) who have worked with you on resolving your query..
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks