Formula to calculate due dates

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
dcantel1Asked:
Who is Participating?
 
bromy2004Connect With a Mentor Commented:
Change the COUNTIF to >7
=COUNTIF(G5,">7")
0
 
Saurabh Singh TeotiaConnect With a Mentor Commented:
Use this formula.It will give you answer as true or false.
=AND(G5>0,G5<7)
Saurabh.
0
All Courses

From novice to tech pro — start learning today.