Date Formating within a text cell

R

Rob

How can I format the date to display "March 1,2010" in the following formula?
="Volume moved between February 10, 2010 and "&TODAY()&" as determined"
current result is = Volume moved between February 10, 2010 and 40238 as
determined
 
D

Dave Peterson

="..." & text(today(), "mmmm d, yyyy") & "...."


How can I format the date to display "March 1,2010" in the following formula?
="Volume moved between February 10, 2010 and "&TODAY()&" as determined"
current result is = Volume moved between February 10, 2010 and 40238 as
determined
Click to expand...
 

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

Cell Formating 2
Splitting data in a cell 2
Convert Text to Date Month and Year 1
Summing the number of incomplete jobs within a date range -sumprod 6
Formula not reading date format 3
Splitting data in a cell 1
SUMIF Formula Help 8
vLookup, Look up Value 1

Top