On Mon, 16 Jul 2007 19:52:05 -0700, Steffen
wrote:

ok,if i just want use y m d data,how to set ?


I don't understand your question.

What is "y m d data"?

How do you want to "use" it?

In the formula I gave you, A1 must contain a date (which, in Excel,is a serial
number).
--ron