link cell in excel to current date
 

Hi guys,

I'm new here as my "fight" with excel has intensified due to a new
job:) Hope somebody can help.

I'm trying to link a cell in excel to the current date, so that it
refreshes everytime I open the document and displays todays date. Is
that possible, and if how do I do this?

Thanks!


--
Romily
------------------------------------------------------------------------
Romily's Profile: http://www.excelforum.com/member.php...o&userid=36947
View this thread: http://www.excelforum.com/showthread...hreadid=566580

link cell in excel to current date
 

Type this formula in the cell.........

=TODAY()

Vaya con Dios,
Chuck, CABGx3



"Romily" wrote:


Hi guys,

I'm new here as my "fight" with excel has intensified due to a new
job:) Hope somebody can help.

I'm trying to link a cell in excel to the current date, so that it
refreshes everytime I open the document and displays todays date. Is
that possible, and if how do I do this?

Thanks!


--
Romily
------------------------------------------------------------------------
Romily's Profile: http://www.excelforum.com/member.php...o&userid=36947
View this thread: http://www.excelforum.com/showthread...hreadid=566580

link cell in excel to current date
 

=today()


"Romily" wrote in
message :

Hi guys,

I'm new here as my "fight" with excel has intensified due to a new
job:) Hope somebody can help.

I'm trying to link a cell in excel to the current date, so that it
refreshes everytime I open the document and displays todays date. Is
that possible, and if how do I do this?

Thanks!


--
Romily
------------------------------------------------------------------------
Romily's Profile: http://www.excelforum.com/member.php...o&userid=36947
View this thread: http://www.excelforum.com/showthread...hreadid=566580

link cell in excel to current date
 

thanks a lot!


--
Romily
------------------------------------------------------------------------
Romily's Profile: http://www.excelforum.com/member.php...o&userid=36947
View this thread: http://www.excelforum.com/showthread...hreadid=566580