I have a column for each Banked, Bankable, Borrowed, Used, and Remaining - for each year.
Under K6 I have this formula for "Banked"
=IF(ISBLANK(J6)=true,"0",If(F6<N6,0,F6-N6))
*Basically this formula is grabbing from the previous year only when I enter a date in J6 otherwise it's blank.
Under...