Date and text in a cell

F

fourlugas

I am trying to figure how to put current date +1 and text in a cell W
use this to copy and paste a comment that we make on MANY tickets
day. For example, lets say the cell is this

Your monitor will arrive on 9/2

I want to be able to say

Your Monitor will arrive on =now()+1

-----------

So that I don't have to change the day on that cell everyday to th
next day.

Thank
 
D

Dave Peterson

="Your monitor will arrive on: " & text(today()+1,"mm/dd/yyyy")

is one way.
 
Top