We're aware that some users are experiencing technical issues which the team are working to resolve. See the Community Noticeboard for more info. Thank you for your patience.
📨 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!

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

Options
2»

Comments

  • Mobeer
    Mobeer Posts: 1,851 Forumite
    Part of the Furniture 1,000 Posts Academoney Grad Photogenic
    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
    Snow_Dog Posts: 690 Forumite
    Part of the Furniture Combo Breaker
    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.
This discussion has been closed.
Meet your Ambassadors

🚀 Getting Started

Hi new member!

Our Getting Started Guide will help you get the most out of the Forum

Categories

  • All Categories
  • 350.7K Banking & Borrowing
  • 253K Reduce Debt & Boost Income
  • 453.4K Spending & Discounts
  • 243.7K Work, Benefits & Business
  • 598.5K Mortgages, Homes & Bills
  • 176.8K Life & Family
  • 256.9K Travel & Transport
  • 1.5M Hobbies & Leisure
  • 16.1K Discuss & Feedback
  • 37.6K Read-Only Boards

Is this how you want to be seen?

We see you are using a default avatar. It takes only a few seconds to pick a picture.