Sep 1, 2008

String Date Calculate

  • As Seeing DateValue is String
  • the Difficule to Calculate
  • Follow Convert to Date(number)

  • if Formula Want Below Method

   Hi ! Here Suggest to you

  DataSheet= UseFormula
 
[ How Calculate Date( is STRING ) ] Let's Look & Find
ABCDEF
Cell Formatm/d/yyyyCalculete
Dec-21-2008Dec-31-200810=B2-A2
Dec-21-2008Mar-01-200970=B5-A5
Cell FormatString( Text )StartEndCalculete
Dec/21/2008Dec/31/2008#VALUE!21/Dec/200831/Dec/200810
Dec/21/2008Mar/01/2009#VALUE!21/Dec/200801/Mar/200970

Used Formula ...(With Running MicrosoftExcel Ver 2003)
NoAddr'  If use below Formula, You'll Get Result as RightResultEtc
1C2=B2-A210
2C3=B3-A370
3C6=B6-A6#VALUE!
4C7=B7-A7#VALUE!
5D6=MID(A6,FIND("/",A6)+1,LEN(A6)-FIND(RIGHT(A6,5),A6)-1)&LEFT(A6,FIND("/",A6))&RIGHT(A6,4)21/Dec/2008
6D7=MID(A7,FIND("/",A7)+1,LEN(A7)-FIND(RIGHT(A7,5),A7)-1)&LEFT(A7,FIND("/",A7))&RIGHT(A7,4)21/Dec/2008
7E6=MID(B6,FIND("/",B6)+1,LEN(B6)-FIND(RIGHT(B6,5),B6)-1)&LEFT(B6,FIND("/",B6))&RIGHT(B6,4)31/Dec/2008
8E7=MID(B7,FIND("/",B7)+1,LEN(B7)-FIND(RIGHT(B7,5),B7)-1)&LEFT(B7,FIND("/",B7))&RIGHT(B7,4)01/Mar/2009
9F6=E6-D610
10F7=E7-D770

      How about this suggest?

No comments:

Locations of visitors to this page