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

A

Arif

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

pinmaster

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
 
Top