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?

43Tesseracts
  • 289
  • 3
  • 12

1 Answers1

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:

https://www.365csi.nl/vm365com/365coach/#/Calculated_Column_Functions_List

Danny '365CSI' Engelman
  • 21,176
  • 7
  • 35
  • 79
  • 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 04:07
  • 1
    Thanks for getting me started: =TODAY()+MOD(11-WEEKDAY(TODAY()),7) – 43Tesseracts Oct 18 '15 at 04:28