Hi All

I'm trying to find a formula that gives me the LAST entry in a row based on TODAY()

the row looks like this:

date1 Interest Balance date2 Interest Balance date3 ...etc



What I need is the LAST entry under 'Balance' based on TODAY()

I've got this far, but it doesnt work properly:

{=SUM((N2:FP2<=TODAY()),(N2:FP2="Balance"),N4:FP4)}

(where N4:FP4 contains the actual data)



Can anyone help?
Thanks