Display date in a cell when cell range or colum is modified

Using 07.

I am looking to display the current date in a designated cell when ever a modification to any cell withen a range or colum is made and the document is saved.

I have tried a few things unsuccessfully and would appriciate any help.

I have used this code below to do basically what you are saying but I am also trying to get the date to show up no matter which cell in a range has data inputted to it.


=IF(B3<>"",IF(A3="",TODAY(),A3),"")


if anything is put it cell B3 then the date is put into cell A3, but I have a bunch of cells that can have data inputted and would like the date to show in cell A3 no matter which one gets filled first.

Here are the other cell addresses I am using: F3,J3,N3,R3,V3,Z3,AD3,AH3,AL3.

I don't know how to add these other cells into the formula above to make this work. Any ideas would be greatly appreciated!