ExcelBanter - Data Validation for "Not a Pay day."

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Data Validation for "Not a Pay day." (https://www.excelbanter.com/excel-worksheet-functions/132639-data-validation-not-pay-day.html)

Kaye

Data Validation for "Not a Pay day."

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

JE McGimpsey

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

Kaye

Data Validation for "Not a Pay day."

That's it - thanks!

On Tue, 27 Feb 2007 19:16:52 -0700, JE McGimpsey
wrote:

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

All times are GMT +1. The time now is 07:03 AM.