Feb 11 2022 12:17 PM
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.
Feb 11 2022 01:16 PM
=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")))))
Feb 11 2022 03:26 PM
SolutionFeb 11 2022 04:03 PM
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"]
Feb 11 2022 03:26 PM
Solution