how to compare two arrays?

[Ofer]

Hi,
I have two arrays first one is dates (F6:AK6) the is the number of
items (F7:AK7)
while items can be negative in order to remove item from inventory I
need to count number of days
the item has been in the inventory.
I know how to do this on one item easily but I never done it with an
array..
is it possible to do it with a formula?
I used this for one item
=(IF((DATEDIF(F6,G6,"d"))<15,15,30))*(IF(F7<0,(ABS(F7)))/30)


Thanks

 

[Ofer]

after quite alot of thinking about a way to tackle this problem I think
i'll use vba for this solution
because this is just too hard to do with only fomulas. (don't know
excel that good)
I'll be happy to get some help