Date Formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
="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")
 
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
 
Back
Top