员工号姓名性别出生日期部门退休日期LEFTIF年(LEFT+IF)月（MID）日（MID）日（RIGHT）日（RIGHT+1）DATEA00
1张三男19450620综合部2005/6/211945602005062020212005/6/21A002李四男1951071
4开发部2011/7/151951602011071414152011/7/15A003王五女19790513综合部2034/5/
141979552034051313142034/5/14A004赵六女19741201开发部2029/12/2197455202
912010122029/12/2A005田七男19781229推广部2038/12/3019786020381229293020
38/12/30A006赵八女19520710技术部2007/7/111952552007071010112007/7/11DAT
E(LEFT(D2,4)+IF(C2="男",60,55),MID(D2,5,2),RIGHT(D2,2)+1) |
|
