Who knows the meaning of mdy, ymd, myd, ydm and dym in excel date options? What's the use of being short?

M = month: month; Y = year: year; D = day: day, the time format is different according to different orders.

In the past, the date of birth of employees was entered in excel. For the sake of simplicity, it was always in the format of "YYY-MM-DD", but the higher authorities required it to be in the format of "YYY-MM-DD", such as 20 13-08-27. Then the birth time of 1000 employees must not be changed manually. The method of data decomposition is faster. The options in ymd format are arranged in the order of year, month and day.

Extended data:

Excel is the first spreadsheet software that allows users to customize the interface, including fonts, text attributes and cell formats. The function of "intelligent recalculation" is also introduced. When the cell data changes, only the relevant data will be updated, while the original tabulation software can only recalculate all the data or wait for the next instruction. At the same time, Excel also has powerful graphic functions.

When Excel was first bundled into Microsoft Office in 1993, Microsoft redesigned the interface between Microsoft Word and PowerPoint to adapt to this extremely popular application program at that time.

Excel has supported Visual Basic for Applications (VBA) since 1993. VBA is a powerful tool, which makes Excel form an independent programming environment. With VBA and macros, you can automate manual steps. VBA also allows you to create forms to obtain information entered by users. However, the automation function of VBA also makes Excel the target of macro virus.