CF a cell depending on another cell's date

[Frankxl]

Morning, is there a formula for CF where
let's say A1 is a date
B1 will display the text?
In consequence if A1 is this week, B1 will display the text "this week".
Also displays of "yesterday", "tomorrow", "last month", "next month"
"Last week", "next week" in B1 accordingly to the date on A1.
It does not have to be one formula only unless it can be done with one.
I know how to do it with colors in CF but is a little confusing.

[TMS]

You can't display text with CF. The clue is in the name, Conditional Formatting

You could have a formula in Cell B1 to display the text AND CF to highlight it.

What constitutes "this week"?

[Frankxl]

Okay that'll work too, formula in B1 to display the text will work then.
Do you happen to have one?
Thanks.

[JeteMc]

Assuming dates within the current year, try the following in cell B1:

Please Login or Register  to view this content.

Let us know if you have any questions.

[HansDouwe]

This formula also works well around year transitions:

Please Login or Register  to view this content.

[Frankxl]

Thank you much both!

[HansDouwe]

You are welcome, thx for the feedback and rep .

[JeteMc]

You're Welcome and thank you for the feedback. Please take a moment to mark the thread as 'Solved' using the thread tools menu above your first post. I hope that you have a blessed day.