Formula based on days

[JoeExcelHelp]

Help please

Trying to get this formula to number of days

Code: Select all

=-(IF(AE14<Today()+E3),0,IF(AND(AE133<=AD133,AE133<=MIN(INDEX(($G14:AD14>Today()+E3))*($G133:AD133),))),-(AE133-MIN(INDEX(($G14:AD14>Today()+E3))*($G133:AD133),))),IF(OR(AD133="",AD133=0),IF(AE133>MIN(INDEX(($G14:AD14>Today()+E3))*($G133:AD133),)),0,AE133),0))))

Currently its considering months

Code: Select all

=-(IF(AE14<EOMONTH(TODAY(),$E$3/30-1),0,IF(AND(AE133<=AD133,AE133<=MIN(INDEX(($G14:AD14>EOMONTH(TODAY(),$E$3/30-1))*($G133:AD133),))),-(AE133-MIN(INDEX(($G14:AD14>EOMONTH(TODAY(),$E$3/30-1))*($G133:AD133),))),IF(OR(AD133="",AD133=0),IF(AE133>MIN(INDEX(($G14:AD14>EOMONTH(TODAY(),$E$3/30-1))*($G133:AD133),)),0,AE133),0))))

[JoeExcelHelp]

This first formula keeps highlighting E3 as the problem.. just cant figure out why it doesnt work.. also E3 is a number of day example 50

[HansV]

There shouldn't be a ) after E3. Try

=-(IF(AE14<TODAY()+$E$3,0,IF(AND(AE133<=AD133,AE133<=MIN(INDEX(($G14:AD14>TODAY()+$E$3)*($G133:AD133),))),-(AE133-MIN(INDEX(($G14:AD14>TODAY()+$E$3)*($G133:AD133),))),IF(OR(AD133="",AD133=0),IF(AE133>MIN(INDEX(($G14:AD14>TODAY()+$E$3)*($G133:AD133),)),0,AE133),0))))

[JoeExcelHelp]

Very silly mistake :).. Thank You Hans