Set Sunday of current week to Date and time column in a list using Formula

If we want to set Sunday of current week for a  column in a list then follow the steps below

Add a date and time column to a list

Name it as Date

Select Calculated value radio button under Default value section

in textbox enter formula =1-WEEKDAY(TODAY)+TODAY
 

Sunday of this current week:

=1-WEEKDAY(TODAY)+TODAY 

Monday of this current week:

=2-WEEKDAY(TODAY)+TODAY 

Tuesday of this current week:

=3-WEEKDAY(TODAY)+TODAY 

Wednesday of this current week:

=4-WEEKDAY(TODAY)+TODAY 

Thursday of this current week:

=5-WEEKDAY(TODAY)+TODAY 

Friday of this current week:

=6-WEEKDAY(TODAY)+TODAY 

Saturday of this current week:

=7-WEEKDAY(TODAY())+TODAY() 

SUNDAY of following week, when Monday & not Sunday is used as day #1 of week:

=8-WEEKDAY(TODAY())+TODAY()

Also, if you change the format of the cell to a custom format and choose DDD it will display Fri or Mon and if you use DDDD it will display Friday or Monday, etc.

Reference:

http://superuser.com/questions/376698/how-to-get-the-dates-of-the-current-monday-wednesday-and-friday-of-the-current

http://sridharu.blogspot.in/2009/01/set-default-date-time-to-datetime-field.html