I need to apply functions and formulas to dates in the "yy mm dd" format. Why
was this format not included as a date?

I need for example to subtract date b from date a and return a day for day
result in the format above.

Then I need to be able to add dates in this format. While I can input
numbers in the format above they will not add/subtract like dates ie at 30
they add 1 month to the months.

I did notice that Open Office will format in this way but I prefer Excel.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions