ExcelBanter - Can excel convert a date to text

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Can excel convert a date to text (https://www.excelbanter.com/excel-programming/413079-can-excel-convert-date-text.html)

Hamed parhizkar

Can excel convert a date to text

If in cell B3 i have a date in this format: 6/27/2008. Is there anyway that I
could put a formula in a cell F2 that makes my output read 62708 or 6272008?

Gary''s Student

Can excel convert a date to text

=YEAR(B3)+DAY(B3)*10000+MONTH(B3)*1000000 and format as general
--
Gary''s Student - gsnu200793

"Hamed parhizkar" wrote:

If in cell B3 i have a date in this format: 6/27/2008. Is there anyway that I
could put a formula in a cell F2 that makes my output read 62708 or 6272008?

Charlie

Can excel convert a date to text

=TEXT(A1,"MDDYY")
or
=TEXT(A1,"MDDYYYY")

"Hamed parhizkar" wrote:

If in cell B3 i have a date in this format: 6/27/2008. Is there anyway that I
could put a formula in a cell F2 that makes my output read 62708 or 6272008?

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