|
- =REPLACE(TEXT(MAX(IFERROR(((0&(0&585-(0&ROW($2:$202)*365-CODE(MID("q^isalvcnxep]hs`kublYdo\gr^is`kYdn[ep]hU`kXbmYdo\gT_iVakXcQ[fS]hU_kXbOZdQ\gT_LWaNXcP[HS^KU_LWbPZGR\IT_LWaNYEP[HS^KUBMWDOZGR\ITALWDNYFP=HS@KVCMWDO<GR?JTAK8CN<FQ>HS@K8CM:EO<G4?J7AL9CN;F3>H5@J8C0;E2<G4?J7",ROW($1:$201),1))-A2))-MMULT(MID(BASE(UNICODE(MID("뒶뒮멗딦봦붕뚪땪릭뒮뒮멍멍봥뵒뭔뵪륭륛뒛뒗멋묥뚥뛔뫚늶륗뒗뒗뙋뵊뺥뛔떭늶뤷뤮벖법뵊붥뭕땪몭뉝뤭법몕뭊뛊뭕땚듚멛딫딫몕뺕뚪뫕몵뒶멗멗딦뺓붕떪땪륭뒮뒭멍봦봥뵒뭔뭪륭륛뒛멋멋묥뚥뛔뫚몶륗뒗뒗뙋뚥뺥뚲떬몶뤶뤮벖뵊뵊붥떪땪몭뉝뤭법몕뭊뭕뫕땚뒺멛딫딫몓띊뚪뫕듚뒶멗멎봦뺓뵓떪뚵륭뒮뒭멍봥봥뵒붪뭚땭뒭뒛멋멋몥뭒뛒뫚땛뤷뒗뒗뙋뚥뺥뚪몶몮뤮벗벖뵊뵊붥떪땪멭딮딭몕몕뭊뭕뫕땚멝멛딫몓뚓뜩뚪뫕듚뒶멗딧봖뺓뵒붪뚵땭뒮멎먭봕붒뵒",ROW($1:$201),1)),2),COLUMN($E:$P),1)+29,N(ROW($1:$12)<COLUMN($A:$M))))+1)/86400+(ROW($1900:$2100)&-1&-COLUMN($A:$M))+SIGN(CODE(MID(SUBSTITUTE(SUBSTITUTE("17-6+5/7+507-6+5/7,506/6-6+507,516/6-6,507-516/6-536/7,517-6+507-526/6-6+5/7,546/7+507,516/6-6,507-516/6-6,507-516/6-6+5",7,6.6),6,55),ROW($1:$201),1))-COLUMN($AO:$BA))/2-0.5,"")),"e年h闰d月s日"),6,2,)
复制代码
海鲜大神出品
这是佬们智慧的结晶,记是不可能记的
公历日期写在A2
天书一样
|
-
|