ExcelBanter - Check to see if date is = to Sunday

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Check to see if date is = to Sunday (https://www.excelbanter.com/excel-programming/364640-check-see-if-date-%3D-sunday.html)

Brian

Check to see if date is = to Sunday

I want to prompt the user if the date he entered is not a Sunday. It
might not be the Sunday in the current week but any Sunday. Is this
possible in VBA?

Thanks in advance

Brian

JMB

Check to see if date is = to Sunday

You could probably use the WEEKDAY function.

"Brian" wrote:

I want to prompt the user if the date he entered is not a Sunday. It
might not be the Sunday in the current week but any Sunday. Is this
possible in VBA?

Thanks in advance

Brian

All times are GMT +1. The time now is 07:45 AM.