Thread: Data Validation - 1st or 16th of the month only
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bernd P Bernd P is offline
external usenet poster
  
Posts: 806
Default Data Validation - 1st or 16th of the month only
(DAY(A1)=1)+(DAY(A1)=16)

or

OR(DAY(A1)=1),DAY(A1)=16)
Reply With QuoteReply With Quote