can this be right - surely NOT!! HELP HELP!

Mobeer

Snow_Dog wrote: »

Also, just checked 19th January 2007 to 31st March 2008 is 438 days according to Excel, enter the two dates then subtract one from the other and format the cell as a number, gives 437.

The period mentioned of 19 Jan 2007 to 31 March 2008 includes both days, so is 438 days.

Excel calculates (19 Jan 2007 00:00 - 31 March 2008 00:00) as 437 days. Try (19 Jan 2007 00:00 - 31 March 2008 23:59:59) to get 438 days.

Snow_Dog

Good call, I did think about explaining the extra day as being both end days inclusive but then decided too much hassle, but your explanation is spot on.