| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can Excel 2003 cell link carry with it the source cell format? | Excel Discussion (Misc queries) | |||
| Ms Excel, Copying Cell to current sheet using 'Right Click' | Excel Discussion (Misc queries) | |||
| enter a current date in a cell? | Excel Discussion (Misc queries) | |||
| Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
| How do I program a cell to automaticinput the current date as dat. | Excel Worksheet Functions | |||
Hybrid Mode
