ExcelBanter - I need today's date returned as date format in formula

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

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

- - I need today's date returned as date format in formula (https://www.excelbanter.com/excel-discussion-misc-queries/73479-i-need-todays-date-returned-date-format-formula.html)

CMIConnie

I need today's date returned as date format in formula

I have the following formula: =CONCATENATE("W ",TODAY()). It returns W
38771, but I need it to return W 02/23/06. Is this possible?
I have Excel 2000

Gary''s Student

I need today's date returned as date format in formula

="W " & TEXT(TODAY(),"mm/dd/yy")

--
Gary''s Student

"CMIConnie" wrote:

I have the following formula: =CONCATENATE("W ",TODAY()). It returns W
38771, but I need it to return W 02/23/06. Is this possible?
I have Excel 2000

CLR

I need today's date returned as date format in formula

="W "&TEXT(TODAY(),"mm/dd/yyyy")

Vaya con Dios,
Chuck, CABGx3

"CMIConnie" wrote:

I have the following formula: =CONCATENATE("W ",TODAY()). It returns W
38771, but I need it to return W 02/23/06. Is this possible?
I have Excel 2000

All times are GMT +1. The time now is 02:23 PM.