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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Determine accuracy percentage between two dates 2
Look up in another sheet for values to return in 1st worksheet 2
Conditional SUM of column values depending on the heading (month) 1
Formating tenths and hundreds to show as whole numbers 2
Formulas with if functions???? 3
pivot table help 1
sorting dates in a pivot table 1
Converting 00:15:00 format into metric 1

Back
Top