View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ashish Mathur[_2_] Ashish Mathur[_2_] is offline
external usenet poster
 
Posts: 1,766
Default difference between the dates ex: 4/11/2008- 7/11/2008= 3 days

Hi,

In cell C1, enter B1-A1. Assuming 7/11/2008 is in cell B1 and the other
date is in cell A1. Format C1 as general

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"difference between the dates ex: 4/11/2" <difference between the dates ex:
wrote in message
...
how to caliculate difference between the dates ex: 4/11/2008- 7/11/2008=
3
days