| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can excel automatically enter the date data in a cell was entered | Excel Worksheet Functions | |||
| Excel: How do I enter a date in one cell & automatically dates adj | Excel Discussion (Misc queries) | |||
| how do i make a date change automatically if i change one before . | Excel Discussion (Misc queries) | |||
| How do I calculate interest and deduct late fees based on date pa. | New Users to Excel | |||
| prevent 4/5 in a cell automatically transfer to a date format | Excel Discussion (Misc queries) | |||
Linear Mode
