<Nice explanation, Stephen.

I agree!

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Pete_UK" wrote in message ...
| Nice explanation, Stephen.
|
| Pete
|
| On Nov 30, 4:36 pm, "Stephen" <none wrote:
| Then you will have to add 1 to your subtraction. It isn't Excel insisting on
| anything - it's how arithmetic works! If I give out tickets numbered
| sequentially, starting with number 7 and finishing with 27, how many tickets
| have I given out? Twenty one. But 27 - 7 = 20. To correctly calculate the
| number of tickets, I need to use (last - first + 1). This example directly
| correlates with yours - if the number on each ticket is the day of the
| month.
|
| "Burt" wrote in message
|
| ...
|
|
|
| Hi,
|
| I want to be able to calculate the amount of weeks between 2 dates.
|
| If in A1 I have 07/01/08 (mon) and in B1 I have 28/01/08 (mon) I know I
| can
| do:
|
| =(b1-a1)/7
|
| and it gives me the correct answer - 3 weeks (providing I re-format the
| answer).
|
| However, what my spreadsheet requires is that 1 week should be Monday to
| Sunday, and not Monday to Monday. If I count the amount of days from Mon
| to
| Sun then that should be 7 days....so why does Excel insist I use Mon to
| Mon
| when in fact that is 8 days. How do I get around this problem. (I have
| to
| have the weekday end on a sunday and not a monday).
|
| hope you can help- Hide quoted text -
|
| - Show quoted text -
|