Weekday data validation problem

[Christine]

Can someone help us write the validation criteria for the
following:

We have a cell named WeekEnding. The format is set to a
long Date (1 September 2004).

If the user enters a date that does not occur on a Sunday,
the error message should occur. The current validation
criteria is:
WeekDay(WeekEnding) <1

The error message comes up even if the user types a valid
Sunday date. The logic of the criteria is probably
obviously wrong, but we can't figure out what to try next!

Thanks in advance,
Christine

 

[Ron Rosenfeld]

Can someone help us write the validation criteria for the
following:

We have a cell named WeekEnding. The format is set to a
long Date (1 September 2004).

If the user enters a date that does not occur on a Sunday,
the error message should occur. The current validation
criteria is:
WeekDay(WeekEnding) <1

The error message comes up even if the user types a valid
Sunday date. The logic of the criteria is probably
obviously wrong, but we can't figure out what to try next!

Thanks in advance,
Christine

Your logic is inverted. Try:

=WEEKDAY(WeekEnding)=1


--ron

 

[Myrna Larson]

In addition to you inverted logic, you should note that the WEEKDAY function
with only 1 argument (the date) returns a number between 1 and 7. So the
result will NEVER be < 1.

 

[Christine]

Thank you, Ron and Myrna, for sorting us out!

Christine