getting quantities according to date

O

oferchen

Hi,
I have an excel sheet with two ranges first one is dates the other one
is quantities.
while quantities could be negative.I need to count how many days back
until the quantity is zeroed.
every cell needs to be calculated with above 15 days being equal to one
and below 15 days equals to 0.5
I can't seem to find a way to loop a formula onto a range...

I wrote this formula to calculate the dates
=IF(F7<0,(IF((DATEDIF(F6,G6,"d"))<15,15,30))*(IF(F7<0,(ABS(F7)))/30),)

the date range is F6:AK6 and quantities is F7:AK7

Thanks
Ofer
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to compare two arrays? 1
Using IF function to perform calculation after specific date 2
Help using the DAY() function 8
date of birth age formula 8
Calculating Days Late 1
Excel PRICE function: How does it compute Issue Date of the Security 5
A problem with Nested IFs 0
A problem with nested IF's 0

Top