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