Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming,microsoft.public.excel.misc,microsoft.public.excel.worksheet.functions
|
|||
|
|||
getting quantities according to date
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(F 7<0,(ABS(F7)))/30),) the date range is F6:AK6 and quantities is F7:AK7 Thanks Ofer |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF and Date Functions | Excel Worksheet Functions | |||
insert date | Excel Worksheet Functions | |||
Insert Automatic, Non-Updating Date Stamp | Excel Discussion (Misc queries) | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Another Date issue. | Excel Worksheet Functions |