you should use both formulas in different cells.
like:

A1: =TODAY()
A2: =DAY(A1)


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