Inserting Date + 90 days into a sentence keep getting sate serial number

Question

Excel and Microsoft 365.Hi, I have a document date.&nbsp; I want to use that document date plus 90 days in a sentence as a way to age the document.&nbsp; The sentence is "This proposal expires on {document date plus 90 days}.&nbsp; I can get the date that I need but when I try to incorporate it into a sentence, the best I can get is a serial number for a date.&nbsp; My last attempt was "=CONCAT(B25," ",TEXT(B12,"mm/dd/yy") + 90)" and the result is "This proposal expires on 45759".&nbsp; I've tried a couple of other things as well, I either generate an error or I get the same result (a serial number).&nbsp; By the way, the serial number is correct for the date I'm looking for.&nbsp;Any suggestions would be welcome.&nbsp;Roland

hansvogelaar · Accepted Answer

Use
&nbsp;
=CONCAT(B25," ",TEXT(B12+90,"mm/dd/yy"))

Forum Discussion

Inserting Date + 90 days into a sentence keep getting sate serial number

2 Replies

Resources