SOLVED

If Then Help

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3156309%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3EIf%20Then%20Help%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3156309%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3EHey%20guys%2C%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EI%20am%20having%20problems%20with%20a%20simple%20formula%20(it's%20been%20that%20kind%20of%20day).%20I%20am%20looking%20for%20a%20formula%20that%20will%20change%20the%20Day%23%20in%20gray%2C%20when%20the%20blue%20day%20of%20the%20week%20changes.%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EMonday%20-%20Day%201%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3ETuesday%20-%20Day%202%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EWednesday%20-%20Day%203%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EThursday%20-%20Day%204%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EFriday%20-%20Day%205%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%5C%26quot%3Blia-inline-image-display-wrapper%22%20lia-image-align-inline%3D%22%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Fgxcuf89792%2F%5C%26quot%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F347406iB49BC1F04AEBA98C%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%5C%26quot%3B%22%20role%3D%22%5C%26quot%3Bbutton%5C%26quot%3B%22%20title%3D%22catherine9910_0-1644610543503.png%22%20alt%3D%22%5C%26quot%3Bcatherine9910_0-1644610543503.png%5C%26quot%3B%22%20%2F%3E%26lt%3B%5C%2Fspan%26gt%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance.%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3156309%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EExcel%26lt%3B%5C%2Flingo-label%26gt%3B%3CLINGO-LABEL%3EFormulas%20and%20Functions%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E
Contributor

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

 

catherine9910_0-1644610543503.png

 

 

Thanks in advance.

5 Replies

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

 

best response confirmed by Sergei Baklan (MVP)
Solution
You could also try:
="Day "&MATCH(A1,{"Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday"},0)

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

@JMB17 

Yes, that’s a much more elegant solution.

beautiful