Hopefully the title isn't too confusing, but basically I have two cells containing dates and I want to write a sentence in another cell using those dates. I know that to do this with things that aren't dates you just type in the cell:
="Today is, " & A2 & " Tomorrow is " & B2 & "!"
Where A2 and B2 are strings or numbers.
But when I do the same thing with the dates, it gives me numbers instead of the actual dates (I believe this number is the number of days since 1899). Is there a way to format the dates as, well dates inside of the sentence? I tried DATEVALUE but it didn't work because the cells being referenced aren't strings. Maybe I could convert the referenced cells into strings inside of the function and then use DATEVALUE?
Thanks for the help!