fromatting formulae with text & dates

[Mike Hansen]

hello,
I am trying to format a formula
="yesterdays date"&DATE(YEAR(A1),MONTH(A1),1)
I want to format the date to equal MMM-YY
how would i go about this?

[Toppers]

="yesterdays date "&TEXT(DATE(YEAR(A1),MONTH(A1),1),"MMM-YY")

"Mike Hansen" wrote:

> hello,
> I am trying to format a formula
> ="yesterdays date"&DATE(YEAR(A1),MONTH(A1),1)
> I want to format the date to equal MMM-YY
> how would i go about this?

[Marcelo]

Mike,

try

="Yesterdays date "&text((date(year(a1),month(a1),1)),"mmm yy")

hope it helps
Regards from Brazil
Marcelo

"Mike Hansen" escreveu:

> hello,
> I am trying to format a formula
> ="yesterdays date"&DATE(YEAR(A1),MONTH(A1),1)
> I want to format the date to equal MMM-YY
> how would i go about this?