Excel Weekday Formula

[summerhopkins]

I am in charge of a monthly worksheet for my company. We have what we call "7 habits of hospitality", each day of the week is a "habit". I'm trying to figure out a formula that will have the outcome:

If Monday then "Be Dependable" will show in the cell.
If Tuesday then "Guest Needs" will show in the cell.

and so on.

I've been searching but haven't found a formula that I quite understand. Help is appreciated!

 

[Tetra201]

Try this:

=CHOOSE(WEEKDAY(TODAY(),2),"Be Dependable","Guest Needs","Phrase3","Phrase4","Phrase5","Phrase6","Phrase7")

 

[Chrisdontm]

Try this:

=IF(MOD(TODAY(),7)=1,"Church Day",IF(MOD(TODAY(),7)=2,"Be Dependable",IF(MOD(TODAY(),7)=3,"Guests Needs",IF(MOD(TODAY(),7)=4,"Wednesday Slogan",IF(MOD(TODAY(),7)=5,"Thursday Slogan",IF(MOD(TODAY(),7)=6,"Friday Slogan",IF(MOD(TODAY(),7)=7,"Saturday Slogan")))))))

Of course you will need to edit the slogans in the quotes throughout the formula...


Good choice TETRA201, I don't ever think of the CHOOSE formula...

 

[summerhopkins]

Thank you so much Tetra201 and Chrisdontm! I tried both formulas and it didn't quite do what I was thinking. Attached is a screenshot so you can better understand what I'm trying to do. HABIT FOCUS OF THE DAY should be the cell that is changing according to what day that the AS OF THIS DATE cell is putting out. If 6/1/17 is on a Thursday HFOTD cell should put out "Show Compassion". TIA!

 

[Chrisdontm]

In the cell where you want the phrase, put the formula...

In the formulas remove where it says: "TODAY()"
and replace it with the cell reference where the date is...

It looks like cell. D5

We were never told where the formula would go until now...

 

[summerhopkins]

Chrisdontm; Thank you! That worked perfectly for sheet 1 and 2. For some reason on the remaining pages, all that shows up is false, and I'm not sure why. Do you have any ideas as to why it may be doing that? Thanks in advance!

 

[Tetra201]

...For some reason on the remaining pages, all that shows up is false, and I'm not sure why. Do you have any ideas as to why it may be doing that?

For the posted screenshot, Chrisdontm's formula returns FALSE because MOD("6/3/2017",7) equals to zero.

See if my formula works for you:

=CHOOSE(WEEKDAY(D5),"Church Day","Be Dependable","Guest Needs","Wednesday Slogan","Show Compassion","Friday Slogan","Saturday Slogan")

 

[summerhopkins]

Tetra201 and Chrisdontm, ya'll are awesome! It worked! You don't know how much headache you have saved me, since this is something I have to update monthly. Now all I have to do is change 1 number, and everything will populate for me for the month. Thank you so much!

 

[Tetra201]

You are welcome.