="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?