View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default Days between dates including start day and weekends

With the dates in A1 and B1, use =B1-A1
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"JessP27" wrote in message
...
I need to find the number of days between two days, but I need to include
the
start date, and not the end date.

For example:
Start: 1/7/08
End: 2/6/08
Result = 30

I'm using Excel 2003.
Thanks in advance!