I'm being tortured by the #Value error when trying to simply count the number of occurences between two dates that is <= 10. For example
{=sum(if(close date - open date <= 10,1,0))}
something like that. When I don't use a range the formula works. I need to compare several dates. Therefore, a range is necessary.
Thanks in advance
{=sum(if(close date - open date <= 10,1,0))}
something like that. When I don't use a range the formula works. I need to compare several dates. Therefore, a range is necessary.
Thanks in advance