fromatting formulae with text & dates

M

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?
 
M

Marcelo

Mike,

try

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

hope it helps
Regards from Brazil
Marcelo

"Mike Hansen" escreveu:
 
Top