We’d like to remind Forumites to please avoid political debate on the Forum.
This is to keep it a safe and useful space for MoneySaving discussions. Threads that are – or become – political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!
The Forum now has a brand new text editor, adding a bunch of handy features to use when creating posts. Read more in our how-to guide
can this be right - surely NOT!! HELP HELP!
Comments
-
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.0 -
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.0
This discussion has been closed.
Confirm your email address to Create Threads and Reply
Categories
- All Categories
- 353.6K Banking & Borrowing
- 254.2K Reduce Debt & Boost Income
- 455.1K Spending & Discounts
- 246.7K Work, Benefits & Business
- 603K Mortgages, Homes & Bills
- 178.1K Life & Family
- 260.7K Travel & Transport
- 1.5M Hobbies & Leisure
- 16K Discuss & Feedback
- 37.7K Read-Only Boards