Thread: any formular to deduct an amount automatically on a given date?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
pinmaster
 
Posts: n/a
Default 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?
Reply With QuoteReply With Quote