2

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

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

  • 1
    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
  • 1
    Thanks for getting me started: =TODAY()+MOD(11-WEEKDAY(TODAY()),7) – 43Tesseracts Oct 18 '15 at 4:28

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.