ExcelBanter - Date Formating within a text cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Date Formating within a text cell (https://www.excelbanter.com/excel-discussion-misc-queries/257688-date-formating-within-text-cell.html)

Rob

Date Formating within a text cell

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

Dave Peterson

Date Formating within a text cell

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

Rob wrote:

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

--

Dave Peterson

All times are GMT +1. The time now is 02:03 AM.