SOLVED

Contributor

# If Then Help

Hey guys,

I am having problems with a simple formula (it's been that kind of day). I am looking for a formula that will change the Day# in gray, when the blue day of the week changes.

Monday - Day 1

Tuesday - Day 2

Wednesday - Day 3

Thursday - Day 4

Friday - Day 5

5 Replies

# Re: If Then Help

``=VLOOKUP(Y1,\$AC\$1:\$AD\$5,2,FALSE)``

Why not with VLOOKUP and a reference table in range \$AC\$1:\$AD\$5 for example?

``=IF(Y1="Monday","Day1",IF(Y1="Tuesday","Day2",IF(Y1="Wednesday","Day3",IF(Y1="Thursday","Day4",IF(Y1="Friday","Day5")))))``

best response confirmed by Sergei Baklan (MVP)
Solution

# Re: If Then Help

You could also try:
="Day "&MATCH(A1,{"Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday"},0)

# Re: If Then Help

If the day and weekday number are associated with an actual date, simple formatting would produce a display such as that shown.

``````= TODAY() [custom number format = "dddd"]

= WEEKDAY(date,2)  [custom number format = "Day General"]``````

# Re: If Then Help

Yes, that’s a much more elegant solution.

beautiful