Forum Discussion
RolandVierra
Jan 12, 2025Copper Contributor
Inserting Date + 90 days into a sentence keep getting sate serial number
Excel and Microsoft 365. Hi, I have a document date. I want to use that document date plus 90 days in a sentence as a way to age the document. The sentence is "This proposal expires on {document d...
- Jan 13, 2025
Use
=CONCAT(B25," ",TEXT(B12+90,"mm/dd/yy"))
HansVogelaar
Jan 13, 2025MVP
Use
=CONCAT(B25," ",TEXT(B12+90,"mm/dd/yy"))
- RolandVierraJan 14, 2025Copper Contributor
Hans, thanks so much, worked like a charm.