» Eliminating Negative Values from Date Subtractions
CATEGORY - Excel Date & Time Formulas
VERSION - All Microsoft Excel Versions
Creating a formula to return the number of days between each date in column A and the corresponding deadline in column B.
In cases where the date in column A is later than the deadline, the formula is to return zero rather than a negative number of days.
Solution:
Use the MAX function as shown in the following formula:
=MAX(B2-A2,0)
Book Store:
Recommended Books:
- Financial Statements: A Step-By-Step Guide to Understanding and Creating Financial Reports
- Dictionary of Finance and Investment Terms
- Understanding Financial Statements
- The Complete Book of Business Plans: Simple Steps to Writing a Powerful Business Plan (Small Business Sourcebooks)
- Business Plans Kit for Dummies (With CD-ROM)
- Accounting the Easy Way
Eliminating Negative Values from Date Subtractions
Mhz
Thanks for this formula it works great for counting past days of the current date. The only problem is that you get a 39015 value for any blank cells... How is this fixed? Thanks In Advance
