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