If Then Help

[catherine9910]

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

Thanks in advance.

[#2]

@catherine9910 

=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")))))

[#3 · Accepted solution]

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

[#4]

@catherine9910 

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"]

[#5]

@JMB17 

Yes, that’s a much more elegant solution.

[#6]

beautiful