Checking that a Date is a Weekending Day

[Dembo]

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?

[Tom Schreiner]

Hi

YourVar = UserInputValue

If Not Format(YourVar,"DDDD") = "Sunday" Then
'code to backout here and warn user
End If

Tom

[Aladin Akyurek]

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?

=TEXT(A1,"dddd")="Sunday"

where A1 houses a date.

You can even set up data validation on A1 which uses the above formula.

[Mark W.]

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?

=WEEKDAY(A1)=1

[Dembo]

Thanks guys!

[inarbeth]

You can do this without using VBA. To control the date that is put in cell A1, use Data Validation, select Custom and insert this formula:
=OR(WEEKDAY(A1)=1,WEEKDAY(A1)=7). Unless the date is a Saturday or a Sunday, it will be rejected. I find it helpful to give users an Error Alert telling them what they have done wrong. You might also Format Cell A1 using the Custom Format dddd d mmmm yyy so that the day of the week appears in the cell.

[Yogi Anand]

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

[Mark W.]

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 ]

[Yogi Anand]

On 2002-04-20 12:03, Mark W. wrote:

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 ]

Thanks Mark!
For some reason, when I used
=WEEKDAY(A1)=1 first, it did not work for me, and then when I did force it with
=WEEKDAY(A1)=1=TRUE ... it did! that's why I had flagged it to see if someone else had the same isssue. It looks like when it did not work for me first, I must have made some mistake!
Thanks again for catching that and the explanation of the logic behind it.

Regards!

Yogi Anand