"TODAY" function automatically filled

[imported_unknown]

Hello - of course CTRL + semicolon will insert today's date into a field.

However - please does anybody know how to do this automatically..? eg if A1,A2,A3 are all filled in then TODAY() will be auto-inserted into A4

thanks..

 

[WillR]

try this....

probably a better way

=IF(OR(ISBLANK(A3),ISBLANK(A2),ISBLANK(A1)),"",TODAY())

 

[WillR]

On 2002-10-04 06:44, WillR wrote:
try this....

probably a better way

=IF(OR(ISBLANK(A3),ISBLANK(A2),ISBLANK(A1)),"",TODAY())

Mind you, if you've got a much bigger range than 3 cells you'll probably need to try another way.... if you only want to put today's date in if the whole range is empty/full then you could try downloading ASAP utilities.... I use this all the time and the additional functionality is fantastic.... would reccommend it to anyone -can download free off the net

http://www.asap-utilities.com

and if you have it, you could use this formula in cell A4

=IF(CheckEmptyRange(A1:A3)=FALSE,TODAY(),"")

i.e. if A1:A3 is empty then you get today's date in cell A4

 

[WillR]

hey..... and welcome to the board...

my manners are atrocious!