Office software is closely linked to the PDF,the PDF is also must have to control!
Set home Page Add to Favorites
|
(2) according to the identity of card number for date of birth = CONCATENATE ( "19", MID (E4, 7,2 ),"/", MID (E4, 9,2 ),"/", MID (E4, 11,2)) formula to explain: a. MID (E4, 7,2) identity card number in the year to get that string of numbers b. MID (E4, 9,2) identity card number in the month to get that string of numbers c. MID (E4, 11,2) identity card number for that date to obtain the string figures d. CONCATENATE ( "19", MID (E4, 7,2 ),"/", MID (E4, 9,2 ),"/", MID (E4, 11,2)) The purpose is to string together a number of shows. (3) in accordance with the time to work for years (that is, length of service) = CONCATENATE ( DATEDIF (F4, TODAY (), "y"), "year", DATEDIF (F4, TODAY (), "ym"), "month") explained the formula: a. TODAY () system is currently used to derive the time b. DATEDIF (F4, TODAY (), "y") used to calculate the current system time and the difference in time to work Year of c. DATEDIF (F4, TODAY (), "ym") used to calculate the current system time and the difference in time to participate in the work of the month, ignored the date and year of. d. = CONCATENATE (DATEDIF (F4, TODAY (), "y"), "year", DATEDIF (F4, TODAY (), "ym"), "months") aimed at multiple characters string together show. 5. other that personnel information in this table, we also found that the creation date :31-05-2001 when the show in the same cells. This is how to achieve it? Could it be that you manually add? not, in fact, change this date or that it shows the system current time. TODAY function here is to use TEXT function together and create a message The information includes the current date and the date "dd-mm-yyyy" format, said. specific wording of the formula is: = "Created Date:" & TEXT (TODAY (), " dd-mm-yyyy ") this point, we have the date and time function has been more or less understanding, but also envisaged a number of applications. I believe everyone in this regard with the ongoing research will more widely used. |
