Today function then show text

[vimofoto]

Hello there,

I'm trying to create a logbook for our team. A lot of work to do with a lot of questions.
But first of all. I used the function =TODAY and then i used format to display the date as days (like monday, thuesday,...)
Now i want to display some text into the sheet if it's monday, or thuesday or friday, ...
How can i to this?

Thanx a lot people

[protonLeah]

Suppose A1: =TODAY()

then is some cell, test the weekday number of A1
Say B1: =Choose(Weekday(A1),"","monday words", "tuesday words",...,"friday words","")

depending in what the first day of your week is...

[vimofoto]

then is some cell, test the weekday number of A1

This part i don't understand, sorry

[protonLeah]

...then [in another cell, say B1] test the weekday number [of the date] in A1, with:

Please Login or Register  to view this content.

[vimofoto]

Perfect ! Yesterdag i got some errors but with your help it works. Thx