ExcelBanter - Date Formatting

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Date Formatting (https://www.excelbanter.com/excel-discussion-misc-queries/145281-date-formatting.html)

PFLY

Date Formatting

How can I format this formula: ="Metrics through "&today() so that it
reads Metrics through June 5, 2006 instead of Metrics through 39238. I
cannot get the date to format correctly in this formula.

David Biddulph[_2_]

Date Formatting

="Metrics through "&TEXT(today(),"mmmm d, yyyy") if you're happy with 2007.

If you really do want 2006, then try
="Metrics through
"&TEXT(DATE(YEAR(today())-1,MONTH(today()),DAY(today())),"mmmm d, yyyy")
--
David Biddulph

"PFLY" wrote in message
...
How can I format this formula: ="Metrics through "&today() so that it
reads Metrics through June 5, 2006 instead of Metrics through 39238. I
cannot get the date to format correctly in this formula.

Rick Rothstein \(MVP - VB\)

Date Formatting

How can I format this formula: ="Metrics through "&today() so that it
reads Metrics through June 5, 2006 instead of Metrics through 39238. I
cannot get the date to format correctly in this formula.

I think this will do what you want...

="Metrics through "&TEXT(TODAY(),"mmmm d, yyyy")

Rick

All times are GMT +1. The time now is 02:20 AM.