View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default Data Validation for "Not a Pay day."

One way:

Formula:

=MOD(A1-DATE(2007,1,11),14)=0

In article ,
Kaye wrote:

Hi,

I'm having difficulties setting up DV, using the Custom Formula, to
display the error message "Not a pay day" if the user enters a date
that's not a pay day.

Pay days are ....
Every second Thursday starting from 11-Jan-07, i.e.
11 Jan 07 + every 14 days.

Thanks, Kaye