Need help with formula

  • Thread starter Thread starter JB
  • Start date Start date
J

JB

I tried using this formula to count how many days between two specific
days. I receive a wrong number of arguments error when using the
fucntion below. Any idea's why it won't work?

=Count(IIf([Days Old]>=3 and [Days Old]<=10))
 
One method would be

=Count(IIf([Days Old]>=3 and [Days Old]<=10,1,Null))

Another
=Abs(Sum(IIf([Days Old]>=3 and [Days Old]<=10))
 
Back
Top