Display the words "Today" & "Tomorrow" instead of the day

[BloodyBill]

I can't seem to find this, no matter how much I search. How can I automatically change today's date into the word "Today?"
I want the first column to show the corresponding day of the week, UNLESS it is today.
If it is today, I want it the day of the week to be replaced by either the word "Today."
This has to happen dynamically (change from day to day).
On Thursday, October 29...

The first and second columns would contain the same date, formatted differently.

Thanks for any help!

 

[AlanY]

this should do it

Book1
	A	B
1	Wednesday	28/10/2020
2	Today	29/10/2020
3	Friday	30/10/2020
4	Saturday	31/10/2020
5	Sunday	01/11/2020
Sheet1

Cell Formulas
Range	Formula
A1:A5	A1	=IF(B1=TODAY(),"Today",TEXT(B1,"dddd"))

 

[alansidman]

Book1
	A	B
2	Wednesday	10/28/2020
3	Today	10/29/2020
4	Friday	10/30/2020
5	Saturday	10/31/2020
6	Sunday	11/1/2020
Sheet1

Cell Formulas
Range	Formula
A2:A6	A2	=IF(B2=TODAY(), "Today", B2)

 

[BloodyBill]

That works! Thanks!

 

[daverunt]

Hi,

I took the cue from the title, which asked for "Tomorrow" also.
Took me ages to get the syntax right!

=IF(B1=TODAY()+1,"Tomorrow", IF(B1=TODAY(),"Today",TEXT(B1,"dddd")))

 

[BloodyBill]

Hi,

I took the cue from the title, which asked for "Tomorrow" also.
Took me ages to get the syntax right!

=IF(B1=TODAY()+1,"Tomorrow", IF(B1=TODAY(),"Today",TEXT(B1,"dddd")))

Yes, I wrote the title of this post, and then changed my mind to only need Today. Good to know that if I change my mind back, I can use yours. Thanks!