Excel formula help please

13»

Comments

  • Gers
    Gers Posts: 13,026 Forumite
    Part of the Furniture 10,000 Posts Photogenic Name Dropper
    In that last example #NUM! is the expected answer because A1 is blank, what do you get using this version?

    =DATEDIF(A2,B2,"d")

    🫢 Thanks, that worked. 
  • Gers
    Gers Posts: 13,026 Forumite
    Part of the Furniture 10,000 Posts Photogenic Name Dropper
    Yes that formula is in error.
    You did not do a side replacement so really nothing there has been has been gained

    Maybe correct the formula?

    "Interesting and odd! Looks like Word and Excel have different formats for the quotation marks.  "

    yes interesting but not particularly relevant as you did not copy from Word into Excel but merely typed into Excel did you not?


    A couple of posters had earlier suggested that the difference in the formatting of the quotation marks may have been relevant, so I experimented.
  • Tee hee....that fooled me!

    Great you have solved the problem.
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.1K Banking & Borrowing
  • 252.8K Reduce Debt & Boost Income
  • 453.1K Spending & Discounts
  • 243K Work, Benefits & Business
  • 597.4K Mortgages, Homes & Bills
  • 176.5K Life & Family
  • 256K 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.