Excel 2007 - Auto Deduct On Certain Dates?
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.
Hard to answer without knowing something of your data layout. Maybe an IF statement to compare the date with that stored in the cell.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks