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