Calendar / Date Picker - Only Choose Sunday

[stevie875]

I have been racking my brain, trying to figure out a technique for this..

I am working on an expense form and need a way for the salesman to only select Sunday from the calendar or date picker.
Or even a way for the for the salesman to input any date, and it chooses the beginning Sunday of the week.
For example, if they input "2/2/2016" , it would change to "1/31/2016".

I hope that all makes sense. I can provide images, if necessary.

Thank you for your help!

[mehmetcik]

Why dont you use a simple Userform?

Click on Cell B3 of the attached spreadsheet.

Please Login or Register  to view this content.

[stevie875]

Why dont you use a simple Userform?

I appreciate your reply, Mehmetcik.

My apologizes - I am fairly new to Excel. Most of my knowledge has been from Googling questions.

How would you recommend that I use the Simple Userform?
From my research, it looks like I would need it to pop-up and then have a calendar on it for them to select from? Is there a way to have the calendar gray-out every date, except for Sunday?

Is that correct?