In this article you’ll learn, how to avoid negative values while calculating the number of days between two dates. We’ll use MIN, MAX and DATE function in Microsoft Excel.
Let’s take an example,
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.
Follow below given steps:-
In this way, we can avoid the negative values while calculating the number of days between two dates in Microsoft Excel.
We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at email@example.com.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.