| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to Auto Date a Row when datea is entered?
A | B | C | D
Date | Debit | Credit | Balance 07/29/06 | 10.00 | | 90.00 07/30/06 | 10.00 | | 80.00 *Formula | | | *example: @IF(B10+C10=0,"",TODAY()) Can someone help. I would like to write a macro/formula that will put the date in column a, similar to the foumla I have in the example, however, the date will remain constant for the time a value was placed in B or C and not chance when the day change. Thanks in advance for anyone that has any suggestions or comments on this. -- L. James -- ----------------------------- L. D. James www.apollo3.com/~ljames |
| 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 | |||
| date entered wrong or not as a date | Excel Worksheet Functions | |||
| HOW ?Excel chart auto insert /populate a code based on date | New Users to Excel | |||
| NETWORKDAYS - Multiple Date Selection | Excel Discussion (Misc queries) | |||
| FILL DATES IN VARIOUS CELLS BASED ON A DATE ENTERED IN A SINGLE C. | Excel Discussion (Misc queries) | |||
Threaded Mode
