date is changed, any other to solve this problem without VBA (if
possible)


=IF(ISBLANK(E1),"",DATE(YEAR(TODAY()),MONTH(TODAY ()),DAY(TODAY())))

If the result displays as an integer, format the cell using the date
format
of choice.
--
Kevin Backmann


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=561042