Excel (2010) Function Issue

I have a FUNCTION issue with Excel 2010. The attached screenshot is what I am experiencing. I’m trying to get the difference (quantity) between a date range. As you can see in this screenshot, the amount of days between Sept. 12 and Sept. 19 is 7 days, not 6, as it’s showing (?). Has anyone ever seen anything like there (when an Excel function is inaccurate)????

why dont you just subtract the days?

Because just subtracting the days doesn't resolve my function issue; I want to know WHY Excel is doing this (miscounting). Besides, this is just an example of the function problem; my actual date ranges that I'm doing for a project are far more complex than this simple (head-counting) sample.

Well, doesn't that mean that you have Wed 12th Sept, Thursday, Friday plus Monday, Tuesday and Wed 19th Sept ? NETWORKDAYS gives you the number of WORKING days, excluding weekends and holidays (if specified).

Hope this helps.

Pete

Use function Date Difference - DATEDIF(cell1,cell2,"D") Cells 1 & 2 have your dates in then. The "D" is for days but you can use M or months etc.

Pete is correct and seeing that you wanted it to say 7 days, i figured you were looking for just a simple subtraction.

Very well; thanks so much.