Display masking

[goto_guy]

I seem to remember doing this before, but of course cannot remembe
how.

I'm modifying a quote spreadsheet. Current formatting doesn't permit m
to change the layout too much.

For illustration purposes, cell A1=today().
I want cell A2 to read "Quote expires " 91 days after cell A1

If I enter ="quote expires "&a1+91
cell displays "quote expires 38897"

Isn't there a way to mask the (a1+91) to display as a date?

Thanks for your help

 

[Dave Peterson]

="quote expires " & text(a1+91,"mm/dd/yyyy")

I seem to remember doing this before, but of course cannot remember
how.

I'm modifying a quote spreadsheet. Current formatting doesn't permit me
to change the layout too much.

For illustration purposes, cell A1=today().
I want cell A2 to read "Quote expires " 91 days after cell A1

If I enter ="quote expires "&a1+91
cell displays "quote expires 38897"

Isn't there a way to mask the (a1+91) to display as a date?

Thanks for your help.

 

[Gord Dibben]

="qoute expires " &TEXT(A1+91,"mmmm d" &"," &"yyyy")


Gord Dibben MS Excel MVP