You are using an out of date browser. It may not display this or other websites correctly. You should upgrade or use an alternative browser.
date conversion
About this tag
The date conversion tag on WindowsForum.com covers topics related to changing date formats in Microsoft Excel, specifically within Excel 365. Users seek methods to convert dates from one format to another, such as from DD-MM-YYYY to YYYY-MM-DD. Discussions focus on practical steps and formulas to automate these conversions in Excel cells. The tag is relevant for Windows users working with date data in spreadsheets, particularly those needing to standardize date formats for compatibility or reporting purposes.
A question:
I have a cell in excel with date format DD-MM-YYYY.
This cell has a date for example 19-4-2023.
I have another cell with the format YYYY-MM-DD
How can I automatically convert the date 19-4-2023 to 2023-4-19?
Thanks
José Paiva