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:
Monday of this current week:
Tuesday of this current week:
Wednesday of this current week:
Thursday of this current week:
Friday of this current week:
Saturday of this current week:
SUNDAY of following week, when Monday & not Sunday is used as day #1 of week:
Also, if you change the format of the cell to a custom format and choose
=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