Show a letter depending on which day of the week in a cell

[MUNNA2023]

Monday
Tuesday Friday
Wednesday
Thursday
Friday CELL (N5 DAY) NAME CHANGE WHEN DAY PASSES, IT WILL CHANGE FRIDAY TO MONDAY THEN TUESDAY THEN WEDNESDAY THEN THURSDAY THEN FRIDAY

HERE 5 DAYS NAME I WANT A FORULA, (IF MONDAY THEN = A,) (IF TUESDAY THEN = B,) (IF WEDNESDAY THEN = C,) (IF THURSDAY THEN = D,) (IF FRIDAY THEN = E,)

[RaulSerg]

Please try this:

Please Login or Register  to view this content.

[MUNNA2023]

Screenshot 2024-06-14 021116.pngScreenshot 2024-06-14 021116.png

[RaulSerg]

lul...maybe don't just randomly change your spreadsheet and expect something to still work?

How about this?

Please Login or Register  to view this content.

[JohnTopley]

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

[MUNNA2023]

Not working sir

[MUNNA2023]

@JohnTopley Thank you soo much working 100%

[RaulSerg]

In case of older Excel:

Please Login or Register  to view this content.

or even shorter:

Please Login or Register  to view this content.

What error are you getting exactly?

[MUNNA2023]

Attachment 871935


THIS EXACLTY I WANT, 100% WORKING. THANK YOU SOO MUCH @JohnTopley & @RaulSerg

[MUNNA2023]

Respected Sir,/Madam Please add (SATURDAY = F) AND (SUNDAY = G)

[MUNNA2023]

Respected Sir,/Madam Please add (SATURDAY = F) AND (SUNDAY = G)

[6StringJazzer]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about.

I updated your title to get to the point and reflect your actual question.

[wk9128]

Ans. post#11

Please Login or Register  to view this content.

OR

Please Login or Register  to view this content.

[MUNNA2023]

Thank you soo much working 100% helped me a lot

[wk9128]

Hi MUNNA2023 You're Welcome. Glad to help . Thank You for the feedback .

If you finally get a solution please mark your thread as SOLVED:
- Click Thread Tools above your first post,you will see the word PREFIX on the upper left, press the button to select [SOLVED] select "Mark your thread as Solved".
- you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help
was given. By doing so you can add to the reputation(s) of those who helped.