Hi Rob,

I don't have xl2000 to test this but try the following formula for data
validation.

=AND(B4=A1,B4<=A2,WEEKDAY(B4,1)=1)

--
Regards,

OssieMac


"Rob" wrote:

Good morning,

Excel 2000. I want to trap upon entry into a cell (B4) whether a user has
correctly entered a Sunday date, the date also needs to be between two dates
that are in the spreadsheet (cell A1 start date and cell B2 end date). I
can check the latter part using Data Validation but not whether it is a
Sunday. Guessing that I need to add some VBA code but not too sure where to
start.

Any help welcome.

Thanks, Rob