Date Formating within a text cell

  • Thread starter Thread starter Rob
  • Start date Start date
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
 
="..." & 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...
 
Back
Top