Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Feb 2001
    Thanked 0 Times in 0 Posts

    formula help - blank date (2002 SP3)


    I am trying to determine if the date between when a claim was opened and when it was determined (accepted or rejected) is greater than 65 days. My problem is with claims that have not been determined yet. There is a blank where the determination date should be. Can someone suggest a formula I could use to insert todays date if the date if blank. eg open date (col c) - determined date (col d) = D6-C6 (Col e). Column E is formatted as a number. In Col F ^=COUNTIF(E6,">65"). Currently Column E is showing #VALUE! where there is a blank, and Column F is returning 0. If the number of days between the open date and todays date is greater than 65 I would like to be able to count this item.

    Thanks for any suggestions


  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 28 Times in 28 Posts

    Re: formula help - blank date (2002 SP3)

    You could use


    COUNTIF is, as the name indicates, intended to count a number of cells. It's overkill to use it to return a 0 or 1 depending on the value of a single cell. You could use




    instead, that would be more efficient.

Posting Permissions

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