Thread: count days from a one date to another date
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Niek Otten Niek Otten is offline
external usenet poster
  
Posts: 3,440
Default count days from a one date to another date
=B1-A1, Format as General or Number

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"confused!!" wrote in message
...
If in cell A1 i have a date 09/17/09 and date 10/30/08 in B1 i need to
count
the number of days from A1 to B1

Please provide formula for doing so.

Reply With QuoteReply With Quote