Using IF & AND Formula to Calculate the Balance Days

[shekar_genius]

Dear

I am Using IF & AND formula to calculate the Balance days as on a Day.
However it seems some error as when the date is Equal to or Less than the Day to be calculated is showing Wrong.
Row 275 & 276 in Sheet 1

Secondly in other sheet:-
In row U169 It has the same error.
IN row No 167 to 171, the Balance days has to be calculated from Two Feilds Namely U & X, however the result should be what is mentioned.

Thanks

Shekar

[etaf]

I think this part of the IF statement is incorrect
AND(($AJ$2-P275))<0
theres only ONE condition for AND , also the test is outside the AND, and so in the example sheet its false*

=IF(
AND(($AJ$2-P275)>0,(($AJ$2-P275)>1825))
,0,
IF(
AND(($AJ$2-P275))<0
,1825,1825-($AJ$2-P275)
)
)

[shekar_genius]

HI,

The Formulas at Both Locations AJ275 & AJ276 are Different,,.. Because the Formulae at AJ275 if Applied at AJ276 it gets result which is wrong, and Vice Versa..
I need single formula, to fix both crieteria.

Can u please help.

Thanks

Shekar