» 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 Guide to Understanding Financial Statements
- Windows XP Annoyances
- AWAKEN THE GIANT WITHIN : HOW TO TAKE IMMEDIATE CONTROL OF YOUR MENTAL, EMOTIONAL, PHYSICAL AND FINANCIAL
- Lower Your Taxes - Big Time! : Wealth-Building, Tax Reduction Secrets from an IRS Insider
- Analyzing Markets, Products, and Marketing Plans
- Millionaire Real Estate Mentor : The Secrets of Financial Freedom through Real Estate Investing
No comments have been submitted.
