Plz find the attachment

how to custom?
how to format cell?

Attached Files

12.xlsx (10.2 KB, 15 views)

you have to be more specific...
you need to add column D to what? You mean a total for column d?
Or formatting is what you dont know?
-select the column, right click on selection, format cells, custom, then in type field, write: m.yy
more on formatting:
http://support.microsoft.com/kb/264372

i mean a total for column d?

So you want to sum the dates in Col D ? The result is a date somewhere in the year 2813 ??

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

why do you want to add, say: 1.40, which is january 1940, to 3.59, which is march-1959?? the sum wil give 3.99 (march 1999) which is unusable...
Maybe you want to add the number of month only? not years...
place this formula in E1, and copy it to the last row
=IF(ISERR(MONTH(D1));0;MONTH(D1))
to extract the number of month from date
and sum =SUM(E1:E28) in E29 will give you the result of 35 total number of month for the sample posted

thanks for reply

you are mistaken

i want add d column values in my excel sheet 6.50+3.50+2.00+3.00=15.00 answer
6.50
0-00

6.50 3.50
0-00

3.50 2.00
0-00

2.00 3.00
0-00

3.00
total 15.00

The result is 26.83

only add doted value manual

added firstly two value the result is 9.98

your first two entries, which makes 9.98, as you say, came from:
6.63 +3.35, right?
But:
6.63 is just what you choosed to SEE on screen, the number behind 6.63 is 23163, same for 3.35, the number is 12844, you can format this number to be shown in many ways, but the number behind what you see is the same.

You have to read more about excel date/time format.
A good start could be this:
http://www.cpearson.com/excel/datetime.htm
anyway, if you insist to do this type of calculation, you have to extract month and year (last 2 digits, and transform it as decimal number, in order to add it to month)
(Why on earth do you need this??)
the formula in E1, copied down , is:
=IF(ISERR(MONTH(D1));0;MONTH(D1))+VALUE("0,"&IF(IS ERR(YEAR(D1));0;RIGHT(YEAR(D1);2)))

and the sum is 37,12 , not 26,83

Attached Files

Copy of 12.xlsx-2.xlsx (11.2 KB, 8 views)

thank Catalin.B
i studied new think today days count from 0-jan-1900