What are those dates supposed to be?

1. How can you expect to get 18 regardless and how can you get 5?

2. 31/11/2009 or 11/31/2009 US date format is a non-existent date, so that
will be a text string. There are only 30 days in November

Assume it was 11/30/2009

then the result would be

486 assuming that 01/08/2008 is the first of August 2008, if you are mixing
date format and
the first is US format and Jan 8 2008m then the difference would be 692

--


Regards,


Peo Sjoblom

"Jose" wrote in message
...
I have the following problem with dates:
C3 D3
01/08/2008 31/11/2009


When I ask D3-C3 I get 5 instead of 18. How am I doing wrong?
--
Many thanks for your help,
Jose