Data Validation for "Not a Pay day."

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kaye - 28 Feb 2007 01:39 GMT

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

Reply to this Message

JE McGimpsey - 28 Feb 2007 02:16 GMT

One way:

Formula:

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

> Hi,
>
[quoted text clipped - 7 lines]
>
> Thanks, Kaye

Reply to this Message

Kaye - 28 Feb 2007 10:12 GMT

That's it - thanks!

>One way:
>
[quoted text clipped - 13 lines]
>>
>> Thanks, Kaye

Reply to this Message