ok, I made a new column (I) which contains the result of 'current date' - 'start date'. Hopefully this will help.. My problem is with the below expression..
for some reason I always get a result of '2'![]()
=COUNT(IF(I:I,"<30"),(IF(A:A,"1")))
![]()
ok, I made a new column (I) which contains the result of 'current date' - 'start date'. Hopefully this will help.. My problem is with the below expression..
for some reason I always get a result of '2'![]()
=COUNT(IF(I:I,"<30"),(IF(A:A,"1")))
![]()
Last edited by firebladejr; 04-24-2008 at 12:29 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks