Hmm using the TEXT function you should be able to split it out using MID
assuming the date is in cell A1 try

total for the day
=VALUE(LEFT(TEXT(A1,"dd"),1))+VALUE(MID(TEXT(A1,"d d"),2,1))

total of all
=VALUE(LEFT(VALUE(LEFT(TEXT(A1,"ddmmyyyy"),1))+VAL UE(MID(TEXT(A1,"ddmmyyyy"),2,1))+VALUE(MID(TEXT(A1 ,"ddmmyyyy"),3,1))+VALUE(MID(TEXT(A1,"ddmmyyyy"),4 ,1))+VALUE(MID(TEXT(A1,"ddmmyyyy"),5,1))+VALUE(MID (TEXT(A1,"ddmmyyyy"),6,1))+VALUE(MID(TEXT(A1,"ddmm yyyy"),7,1))+VALUE(MID(TEXT(A1,"ddmmyyyy"),8,1)),1 ))+VALUE(MID(VALUE(LEFT(TEXT(A1,"ddmmyyyy"),1))+VA LUE(MID(TEXT(A1,"ddmmyyyy"),2,1))+VALUE(MID(TEXT(A 1,"ddmmyyyy"),3,1))+VALUE(MID(TEXT(A1,"ddmmyyyy"), 4,1))+VALUE(MID(TEXT(A1,"ddmmyyyy"),5,1))+VALUE(MI D(TEXT(A1,"ddmmyyyy"),6,1))+VALUE(MID(TEXT(A1,"ddm myyyy"),7,1))+VALUE(MID(TEXT(A1,"ddmmyyyy"),8,1)), 2,1))

a bit scruffy though I grant you. Dates are always a bit of a problem.