ExcelBanter - fromatting formulae with text & dates

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - fromatting formulae with text & dates (https://www.excelbanter.com/excel-worksheet-functions/91545-fromatting-formulae-text-dates.html)

Mike Hansen

fromatting formulae with text & dates

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

fromatting formulae with text & dates

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

fromatting formulae with text & dates

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?

All times are GMT +1. The time now is 05:55 AM.