Forum Discussion
Solved
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
Thanks in advance.
- You could also try:
="Day "&MATCH(A1,{"Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday"},0)
5 Replies
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"]=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")))))
