View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Count Between dates

That is because your values are text strings rather than dates. Convert them
to dates first.
--
Gary''s Student - gsnu200904


"juancarlos" wrote:

How can I count between two dates when format for the dates is DD-MM-YY

I need to know how many days are between 21/04/09 and 28/04/09

The solution should be 8 if I use =(A2-A1+1) but Im getting #VALUE!

Im used format = Custom = dd/mm/yy, also General and Number but they are
not working either.

Any suggestions?

--
Juan Carlos