08/02/05 21:26:57
=MOD(IF(OR(MONTH(DATE(LEFT(A1,4)+2000,MID(A1,6,2),RIGHT(A1,2)))<3),YEAR(DATE(LEFT(A1,4)+2000,
MID(A1,6,2),RIGHT(A1,2)))-1,YEAR(DATE(LEFT(A1,4)+2000,MID(A1,6,2),RIGHT(A1,2))))+INT(IF(OR(MO
NTH(DATE(LEFT(A1,4)+2000,MID(A1,6,2),RIGHT(A1,2)))<3),YEAR(DATE(LEFT(A1,4)+2000,MID(A1,6,2),R
IGHT(A1,2)))-1,YEAR(DATE(LEFT(A1,4)+2000,MID(A1,6,2),RIGHT(A1,2))))/4)-INT(IF(OR(MONTH(DATE(L
EFT(A1,4)+2000,MID(A1,6,2),RIGHT(A1,2)))<3),YEAR(DATE(LEFT(A1,4)+2000,MID(A1,6,2),RIGHT(A1,2)
))-1,YEAR(DATE(LEFT(A1,4)+2000,MID(A1,6,2),RIGHT(A1,2))))/100)+INT(IF(OR(MONTH(DATE(LEFT(A1,4
)+2000,MID(A1,6,2),RIGHT(A1,2)))<3),YEAR(DATE(LEFT(A1,4)+2000,MID(A1,6,2),RIGHT(A1,2)))-1,YEA
R(DATE(LEFT(A1,4)+2000,MID(A1,6,2),RIGHT(A1,2))))/400)+INT(26*(IF(OR(MONTH(DATE(LEFT(A1,4)+20
00,MID(A1,6,2),RIGHT(A1,2)))<3),MONTH(NULLPO(LEFT(A1,4)+2000,MID(A1,6,2),RIGHT(A1,2)))+12,MONTH
(DATE(LEFT(A1,4)+2000,MID(A1,6,2),RIGHT(A1,2))))+1)/10)+(DAY(DATE(LEFT(A1,4)+2000,MID(A1,6,2)
,RIGHT(A1,2))))-1,7)