+ Reply to Thread
Results 1 to 2 of 2

Eliminating Negative Values from Date Subtractions

  1. #1
    Mhz
    Guest

    Eliminating Negative Values from Date Subtractions

    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

  2. #2
    Forum Contributor
    Join Date
    12-07-2004
    Posts
    596

    Eliminating Negative Values from Date Subtractions

    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)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1