| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Keeping a date when today's date changes
Can someone assist me with this. If I place a "Y" into column 2 (Tested), I would like "Today's Date" to show in the "Date" column. When Today's Date changes to the next day I want the previous dates (Column 1) to stay. Can someone help. I'm having a rough time and I'm sure it's pretty simple.  Today's Date 6/2/2006 Column 1 (Tested) Y (Date) 6/1/2006 Column 2 (Tested) Y (Date) 6/2/2006 -- dps9460 ------------------------------------------------------------------------ dps9460's Profile: http://www.excelforum.com/member.php...o&userid=14725 View this thread: http://www.excelforum.com/showthread...hreadid=548038 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Keeping a date when today's date changes
http://www.mcgimpsey.com/excel/timestamp.html
just change now to today -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com "It is a good thing to follow the first law of holes; if you are in one stop digging." Lord Healey "dps9460" wrote in message ... Can someone assist me with this. If I place a "Y" into column 2 (Tested), I would like "Today's Date" to show in the "Date" column. When Today's Date changes to the next day I want the previous dates (Column 1) to stay. Can someone help. I'm having a rough time and I'm sure it's pretty simple. Today's Date 6/2/2006 Column 1 (Tested) Y (Date) 6/1/2006 Column 2 (Tested) Y (Date) 6/2/2006 -- dps9460 ------------------------------------------------------------------------ dps9460's Profile: http://www.excelforum.com/member.php...o&userid=14725 View this thread: http://www.excelforum.com/showthread...hreadid=548038 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Keeping a date when today's date changes
:) :) :) All I needed was a little hint. I knew it was simple but could not put my finger on it. Thanks for the fast reply Dave -- dps9460 ------------------------------------------------------------------------ dps9460's Profile: http://www.excelforum.com/member.php...o&userid=14725 View this thread: http://www.excelforum.com/showthread...hreadid=548038 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Today's date as vertical line on a chart | Charts and Charting in Excel | |||
| Highlighing values on todays date | New Users to Excel | |||
| How do I sum a range if the date is is greater than today's date? | Excel Worksheet Functions | |||
| in excel how do enter today's date on a laptop | New Users to Excel | |||
| Setting today's date automatically in Excel. | Excel Worksheet Functions | |||
Linear Mode
