Skip to main content

Comparing a Day of Week in a dropdown to TODAY(DAY())

  • March 27, 2018
  • 3 replies
  • 25 views
1

Hello, Having a lot of fun with the formulas.

I have a field “Day of Week” with options like “Monday”,“Tuesday”, etc.

I want to create a formula in a second field called field2.

Something like IF ({Day of Week"}=“Monday”,“1,”") OR IF ({Day of Week"}=“Tuesday”,“2,”")
etc… I cannot seem to find the best way to do that.

Any help/direction Appreciated.

Thank you!

    3 replies

    A
    Forum|alt.badge.img+18

    This worked in my table (testing your example):

    IF(DayOfTheWeek=“Monday”,1,
    IF(DayOfTheWeek=“Tuesday”,2,
    IF(DayOfTheWeek=“Wednesday”,3,
    IF(DayOfTheWeek=“Thursday”,4,
    IF(DayOfTheWeek=“Friday”,5,
    IF(DayOfTheWeek=“Saturday”,6,
    IF(DayOfTheWeek=“Sunday”,7,"")))))))

    You may replace DayOfThe Week by {Day of Week}
    Make sure you delete the " in {Day of Week"}

    E
    Forum|alt.badge.img+17

    What is your use case? You already have a WEEKDAY function. Maybe we could advice in other ways.

    1
    • 118_GROUP
    • Author
    • New Participant
    • March 27, 2018

    Thanks @Andre_Zijlstra , that IF statement worked!

    Terms & ConditionsAccessibility statement