ExcelBanter - How can I covert dates to ccyymmdd?

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How can I covert dates to ccyymmdd? (https://www.excelbanter.com/excel-worksheet-functions/98971-how-can-i-covert-dates-ccyymmdd.html)

Payroll

How can I covert dates to ccyymmdd?

Thank you for your help

Niek Otten

How can I covert dates to ccyymmdd?

FormatCellsCustom
In the Type box, enter:
yyyymmdd

If you need a text string that has these digits:

=TEXT(A1,"yyyymmdd")

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Payroll" wrote in message ...
| Thank you for your help

Marcelo

How can I covert dates to ccyymmdd?

HI,

try

=left(year(a2),2)&text(a2,"yymmdd")

hth
regards from Brazil
Marcelo

"Payroll" escreveu:

Thank you for your help

All times are GMT +1. The time now is 04:16 PM.