try this
=SUBSTITUTE(B3,.,-)-SUBSTITUTE(A3,.,-)
On Sun, Apr 17, 2011 at 5:41 PM, Mohd Sanusi Mohd Noor
sanus...@gmail.comwrote:
Dear all,
Would like to seek your kind assistance/help on the date format.
I've a data on date derive from SAP, when transfer to excel the date is in
text
That solution, although not entirely wrong, would not work on all
computers.
This is mainly caused because there are many potential problems :
1) the date items separator (here .)
2) the date structure of the text field (here it is ddmm)
3) the date structure as used by your system (could be