-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
barry houdini
MrExcel MVP
- Joined
- Mar 23, 2005
- Messages
- 20,825
If you have a date in A1 try this in B1
=IF(AND(A1<>"",WEEKDAY(A1,2)>5),"Weekend",OK")
....or you might want to try Data Validation to stop a non weekday being entered in the first place....
=IF(AND(A1<>"",WEEKDAY(A1,2)>5),"Weekend",OK")
....or you might want to try Data Validation to stop a non weekday being entered in the first place....
Upvote
0
Similar threads
- Question
- Solved
