View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
L. D. James L. D. James is offline
external usenet poster
 
Posts: 1
Default 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