On 2002-04-16 00:07, Dembo wrote:
I have a report that requires a user to input a date, this has to be a weekending day. ie. Sunday
How can I write some code to check that the date string is a "Sunday" date?
On 2002-04-16 00:07, Dembo wrote:
I have a report that requires a user to input a date, this has to be a weekending day. ie. Sunday
How can I write some code to check that the date string is a "Sunday" date?
On 2002-04-20 11:45, Yogi Anand wrote:
Hi Dembo:
If you are going to use DATA|VALIDAION|SETTINGS|ALLOW|Formula, then you want to use
=WEEKDAY(A1)=1=TRUE ... I need =TRUE in Excel 97
HTH
On 2002-04-20 12:03, Mark W. wrote:
On 2002-04-20 11:45, Yogi Anand wrote:
Hi Dembo:
If you are going to use DATA|VALIDAION|SETTINGS|ALLOW|Formula, then you want to use
=WEEKDAY(A1)=1=TRUE ... I need =TRUE in Excel 97
HTH
Yogi,
The '=TRUE' portion of your expression above is unnecessary because...
=(condition)=TRUE
...will always return the condition. For example...
=FALSE=TRUE is FALSE
=TRUE=TRUE is TRUE
This message was edited by Mark W. on 2002-04-20 12:04