close
can onyone tell me how to create a formular, to deduct or add an amount
automatically into a worksheet, 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
quot;Arifquot; wrote:
gt; can onyone tell me how to create a formular, to deduct or add an amount
gt; automatically into a worksheet, on a given date?
全站熱搜
留言列表
