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?
WEEKDAY() function gives you a number of the day (sunday = 1)
Which makes your Calculated Value Formula:
=Today() + Weekday( Today() )-3
Incorrect formula corrected by OP:
- 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