IF formula with too many nestings

[jimmisavage]

Good afternoon,
Can anyone help me - I'm trying to work out how to calculate the difference between today's value (currently in cell B8) and yesterday's value (currently in cell B7). The days of the month are set down column B.

I started to use this formula where G2 is =now() Column A has the dates of the month and Column B has the value:
=IF(G2=A8,B8-B7,IF(G2=A9,B9-B8,IF(G2=A10,B10-B9,IF(G2=A11,B11-B10,IF(G2=A12,B12-B11,IF(G2=A13,B13-B12,IF(G2=A14,B14-B13,IF(G2=A15,B15-B14,""))))))))

I need to add more 'nestings' to be able to continue this for the entire month but it won't let me. Is there an easier way I can do this?

Help is greatly appreciated.

[Izandol]

I will suggest additional cell G3 contains:
=MATCH(G2,A8:A38,0)
to find position of today's date. Then result formula is:
=INDEX(B8:B38,G3)-INDEX(B8:B38,G3-1)

[daffodil11]

=SUMPRODUCT((A8:15=G2)*(B8:15-B7:B14))

expand the ranges as needed

[bebo021999]

Assuming date list from A2 down.
=SUMPRODUCT(($A$3:$A$41=G2)*($B$3:$B$41-$B$2:$B$40))

[jimmisavage]

Thanks for all the replies.
=SUMPRODUCT(($A$3:$A$41=G2)*($B$3:$B$41-$B$2:$B$40)) does work if i manually type the date into cell G2 but it doesn't if i use the =now() command, it give me an answer of 0.

Is there anything I can do about this?

[Ace_XL]

The NOW() function takes into account the time too. Use the TODAY() function instead

[jimmisavage]

Perfect! Thanks everyone, as always

[daffodil11]

Thanks for the feedback. Glad we were able to help.