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!
Excel formula help please
Comments
-
double_dutchy said: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.
0 -
Heedtheadvice said:Yes that formula is in error.You did not do a side replacement so really nothing there has been has been gainedMaybe 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.
0 -
Tee hee....that fooled me!Great you have solved the problem.0
Confirm your email address to Create Threads and Reply
Categories
- All Categories
- 352.2K Banking & Borrowing
- 253.6K Reduce Debt & Boost Income
- 454.3K Spending & Discounts
- 245.2K Work, Benefits & Business
- 600.9K Mortgages, Homes & Bills
- 177.5K Life & Family
- 259K Travel & Transport
- 1.5M Hobbies & Leisure
- 16K Discuss & Feedback
- 37.7K Read-Only Boards