Restrict Sunday from entering

[abdulncr]

Hi Friends,


In the column A4:A500 i am entering different date with formate set DDDD-MMMM-YYYY, I wanted excel to restrict when we enter date which is falling on sunday.


Appreciated your help.


Regards

Abdul.

 

[shrivallabha]

Hi Abdul,


Select cell A4


Select

Data Validation | Custom


And then put following formula:

=ISERROR(SEARCH("Sun",TEXT(A4,"ddd"),1))


If you are satisfied with results then copy cell A4 and then select all cells where you want this to happen and do


Paste Special | Validation

 

[abdulncr]

Thank you ShriVallaba. it is working fine.