Excel 2007 : Excel 2007 - Auto Deduct On Certain Dates?

[scaramonga]

Hello all!

A little help would be appreciated on this guys

How can I have Excel 2007 automatically deduct payments on certain dates?

Example:

A £60.00 payment shows in one cell alongside the date due in another cell, so 08/05/2008 - £60.00. Because we have not reached that date as yet, then the total balance in another cell is not updated/reflected until that date is reached.

Best way I can explain it LOL!

Any help much appreciated.

[royUK]

Hard to answer without knowing something of your data layout. Maybe an IF statement to compare the date with that stored in the cell.