» Eliminating Negative Values from Date Subtractions
CATEGORY - Excel Date & Time Formulas
VERSION - All Microsoft Excel Versions
Problem: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:
- The Interpretation of Financial Statements
- The Intelligent Investor: The Classic Bestseller on Value Investing
- Marketing Plan: A Handbook with Marketing Plan
- Essentials of Investments with Standard & Poor's Educational Version of Market Insight + PowerWeb + Stock Trak Coupon
- Microsoft Windows XP Inside Out
- Microsoft Outlook 2002 for Dummies
No comments have been submitted.
