Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

next wednesday

i am trying to make a calculated column that returns the date of the next wednesday, any one can help me with this?

Need Help
Show and Tell
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , Try like

    will give next Wednesday

    [Date] - weekday([Date],2)+10
    Toaday() - weekday(Toaday(),2)+10

8 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Anonymous , Try like

    will give next Wednesday

    [Date] - weekday([Date],2)+10
    Toaday() - weekday(Toaday(),2)+10

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      i am not sure what you mean

      • amitchandak's avatar
        amitchandak
        Super User
        5 years ago

        Anonymous , you can create columns like that will you next Wednesday date

         

         

        Date Next wed = [Date] - weekday([Date],2)+10
        Date Next wed = Toaday() - weekday(Toaday(),2)+10

         

        or measure

         

        Date Next wed =max([Date]) - weekday([max([Date]),2)+10

         

        Date Next wed =Toaday() - weekday(Toaday(),2)+10