Hi All,
I am working on a roster sheet which i need to compile from various users. In the template that i want to circulate for standardization of the roistering process, i want to set up a condition in Cell D1 to accept only dates for Monday as Week start date. And if not then it should display a Pop up mesg. and not let user proceed or save the file.

Else I need excel to display an error Pop Up if the formula result in Cell E1 is not Monday.