| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional formatting for cell date to equal today's date | Excel Worksheet Functions | |||
| Date Formatting (*) | Excel Discussion (Misc queries) | |||
| Formatting Date | Excel Discussion (Misc queries) | |||
| XML date formatting | Excel Worksheet Functions | |||
| date formatting | Excel Discussion (Misc queries) | |||
Linear Mode
