Thread: Count days between text dates
View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default Count days between text dates
Why can't you change the dates to numbers?

One method for doing so.

Select A1 and DataText to ColumnsNextNextColumn Data FormatDateMDY and
Finish.

Same for B1


Gord Dibben MS Excel MVP

On Tue, 11 Aug 2009 08:18:01 -0700, Benny
wrote:

Hello, I need to count the number of days between dates also the months are
in spelled out. I can't change them to numbers. So, is there a way to count
days if cell A1 is Sep/5/2008 and cell B1 is Oct/25/2009?

Reply With QuoteReply With Quote