Collection date numbers

[shimaa01234]

How are collected date of numbers as shown in View
I am using Office 2003
Thanks very much

[oeldere]

see the attached file.

please reply

[JohnTopley]

In your first 2 examples you have treated day as one number (18,15) where as in the remaining examples you have 15 as separate numbers i.e 1+5>

Which is correct?

[shimaa01234]

Thank you very much, Mr. "oeldere"
This is what required
You are genius
Solving wonderful
God bless you

[oeldere]

if the question is solved, will you mark it solved.

You can add rep(utationpoints) to the forummembers, who helped you by clicking on the star on the left side.

[JohnTopley]

See my previous comment: logic is inconsistent.

[shimaa01234]

Thank you very much, Mr. "johntopley"
On this note

[JohnTopley]

... So solution provided should be

F2 =TEXT(A2,"yyyymmdd")

G2 =MID(F2,1,1)+MID(F2,2,1)+MID(F2,3,1)+MID(F2,4,1)+MID(F2,5,1)+MID(F2,6,1)+MID(F2,7,1)+MID(F2,8,1)

[JohnTopley]

Better solution

=SUM(VALUE(MID(F2,ROW($A$1:OFFSET($A$1,LEN(F2)-1,0)),1)))

Enter with Ctrl+Shift+Enter

[shimaa01234]

Thank you very much, Mr. "johntopley"
This formula is simple and wonderful
God bless you