any formular to deduct an amount automatically on a given date?
 

can onyone tell me how to create a formular, to deduct or add an amount
automatically into a worksheet, on a given date?

any formular to deduct an amount automatically on a given date?
 

Something like:

Assuming A1 is a date.

=IF(A1=TODAY(),B1-C1,B1+C1)
or
=IF(A1=DATE(2005,01,15),B1-C1,B1+C1)
or
=IF(TODAY()=DATE(2006,01,15),B1-C1,B1+C1)

HTH
JG



"Arif" wrote:

can onyone tell me how to create a formular, to deduct or add an amount
automatically into a worksheet, on a given date?