Hi,

Try this:

=IF(A1<>"", "Deposited on" & TEXT(TODAY(),"dd-mmm-yyyy"))

or

=IF(A1<>"", "Deposited on" & TEXT(NOW(),"dd-mmm-yyyy"))

Please note that both functions NOW and TODAY are volatile so they will
change as time passes. If you want to fix the date you will have to copy it
and paste values.

Also, your formula will return FALSE if the cell A1 is blank. To avoid that
do this:

=IF(A1<>"", "Deposited on" & TEXT(TODAY(),"dd-mmm-yyyy"),"")

Regards,
KL

"Lewis Koh" <[email protected]> wrote
in message news:[email protected]...
>
> A B
> 1 $100 =IF(NOT(ISBLANK(A1)), "Deposited on" + NOW())
>
> Can I join a string like "Deposited on" with a function like above? I
> wanted to make it auto update on the date when I key in $100.
>
> Why does =IF(NOT(ISBLANK(A1)),NOW()) shows 38563.68864? I can't get the
> date out.Pls help
>
>
> --
> Lewis Koh
> ------------------------------------------------------------------------
> Lewis Koh's Profile:
> http://www.excelforum.com/member.php...o&userid=25712
> View this thread: http://www.excelforum.com/showthread...hreadid=391511
>