Excel Data Validation - date cell but only allow Fridays

[scotthannaford1973]

Hi

I have a cell where users enter a date. I can set the validation criteria to allow only data formats - that's fine... but I want to set up validation rule on the cell to only allow dates that are a Friday.

TIA

 

[Joe4]

Use the Custom (formula) option of Data Validation, like this (for an entry in cell M1):

=WEEKDAY(M1)=6

 

[scotthannaford1973]

Use the Custom (formula) option of Data Validation, like this (for an entry in cell M1):

=WEEKDAY(M1)=6

Well that was annoyingly easy - cheers, Joe.

 

[Joe4]

You are welcome!