Date Formatting

P

PFLY

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.
 
D

David Biddulph

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

Rick Rothstein \(MVP - VB\)

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.
Click to expand...

I think this will do what you want...

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

Rick
 
Top