Solved

# Formula to calculate due dates

Posted on 2010-01-07
243 Views
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 dont 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
0
Question by:dcantel1

LVL 10

Accepted Solution

Change the COUNTIF to >7
=COUNTIF(G5,">7")
0

LVL 59

Assisted Solution

Use this formula.It will give you answer as true or false.
=AND(G5>0,G5<7)
Saurabh.
0

## Featured Post

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.