» Avoiding Negative Values when Calculating the Number of Days between Two Dates
CATEGORY - Excel Date & Time Formulas
VERSION - All Microsoft Excel Versions
We want to create a formula to calculate the number of days between each pair of dates in columns A & B, but the formula is never to return a negative value.
Empty cells in column A are to be considered the first day of the year, and empty cells in column B are to be considered the last day of the year.
Solution:
Use the MAX, MIN, and DATE functions as shown in the following formula:
=MIN(B2,DATE(2005,12,31))-MAX(A2,DATE(2005,1,1))
Book Store:
Recommended Books:
- Managing by the Numbers: A Commonsense Guide to Understanding and Using Your Company's Financials: An Essential Resource for Growing Businesses
- Special Edition Using Microsoft Office XP
- The Essential 55: An Award-Winning Educator's Rules for Discovering the Successful Student in Every Child
- How to Use Financial Statements: A Guide to Understanding the Numbers
- The Complete Book of Business Plans: Simple Steps to Writing a Powerful Business Plan (Small Business Sourcebooks)
- Special Edition Using Microsoft Word 2002
No comments have been submitted.
