Formula to calculate due dates

Posted on 2010-01-07
Last Modified: 2012-05-08
Good day and Happy Holidays!! I need a little bit of help with some formulas.  I need a formula that can turn true or false (as 1, 0) if the number is less than 7 but I dont want it to count the negative numbers.
I tried this unsuccessfully:
=COUNTIF(G5,"<7, >0")           In where G5 = -22
=IF(G6<7>0,1,0)                 In where G6 = 1
This is for a spreadsheet I created to keep track of due dates. The G column are Days Past Due (which I got from this formula: =NETWORKDAYS(H6,TODAY())  H6 = any due date, in this case 1/7/10).
Thanks, dcantel1
Question by:dcantel1
    LVL 10

    Accepted Solution

    Change the COUNTIF to >7
    LVL 59

    Assisted Solution

    by:Saurabh Singh Teotia
    Use this formula.It will give you answer as true or false.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    INDEX and MATCH can be used to great effect to replace HLOOKUP and VLOOKUP as it does not have the limitation of needing the data to be sorted so that the reference value is in the first column or row. It also has the ability to perform a bi-directi…
    Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
    This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
    This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now