# Date column with default value as calculated value that gives the next Wednesday

I have a List Column that is Date only. I would like it to default to the next Wednesday (or today if today is Wednesday). What can I put in the `Calculated Value` field so that it defaults to Wednesday?

## 1 Answer

The `WEEKDAY()` function gives you a number of the day (sunday = 1)

So Wednesday=4

Which makes your Calculated Value Formula:

``````=Today()  +  Weekday( Today() )-3
``````

Incorrect formula corrected by OP: `=TODAY()+MOD(11-WEEKDAY(TODAY()),7)`

• You can use `Today()` in Calculated Values, Validation and View Filters.
But in a Calculated Column Formula only updates when the Item is updated, so effectivly is the same as `Modified` (see: How to use Today and Me in Calculated column)

More Functions at: http://viewmaster365.com/365coach/#/Calculated_Column_Functions_List

• This will need a bit more work. If today is Tuesday, this calculated value would give you today + 2 - 3 = yesterday. Hint: you need a formula that always gives today plus 0 or more. – Dan Henderson Oct 18 '15 at 4:07
• Thanks for getting me started: =TODAY()+MOD(11-WEEKDAY(TODAY()),7) – 43Tesseracts Oct 18 '15 at 4:28