Enter todays date next to text using if error

[thursday140]

Good morning,

I would like to add the date next to text. Please see sample sheet.

Thank you!

[JohnTopley]

Try

="Out sick "& TEXT(TODAY(),"mm/dd/yy")

Replace TODAY() with the cell containing the date [if required]

[Pepe Le Mokko]

If you want to keep the date,different methods ( formulas and VBA) are described at https://excelchamps.com/excel-basics/timestamp/ ( among others)
Just replace NOW() with TODAY() in the formulas ( be careful to read the ENTIRE procedure).