Used Formula ...(With Running MicrosoftExcel Ver 2003) |
No | Addr' | If use below Formula, You'll Get Result as Right | Result | Etc |
1 | C2 | =B2-A2 | 10 | |
2 | C3 | =B3-A3 | 70 | |
3 | C6 | =B6-A6 | #VALUE! | |
4 | C7 | =B7-A7 | #VALUE! | |
5 | D6 | =MID(A6,FIND("/",A6)+1,LEN(A6)-FIND(RIGHT(A6,5),A6)-1)&LEFT(A6,FIND("/",A6))&RIGHT(A6,4) | 21/Dec/2008 | |
6 | D7 | =MID(A7,FIND("/",A7)+1,LEN(A7)-FIND(RIGHT(A7,5),A7)-1)&LEFT(A7,FIND("/",A7))&RIGHT(A7,4) | 21/Dec/2008 | |
7 | E6 | =MID(B6,FIND("/",B6)+1,LEN(B6)-FIND(RIGHT(B6,5),B6)-1)&LEFT(B6,FIND("/",B6))&RIGHT(B6,4) | 31/Dec/2008 | |
8 | E7 | =MID(B7,FIND("/",B7)+1,LEN(B7)-FIND(RIGHT(B7,5),B7)-1)&LEFT(B7,FIND("/",B7))&RIGHT(B7,4) | 01/Mar/2009 | |
9 | F6 | =E6-D6 | 10 | |
10 | F7 | =E7-D7 | 70 | |
How about this suggest?
|
No comments:
Post a Comment