LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
dps9460
 
Posts: n/a
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Today's date as vertical line on a chart ChartQuestion Charts and Charting in Excel 1 June 1st 06 01:27 AM
Highlighing values on todays date JamStev New Users to Excel 3 March 29th 06 10:09 AM
How do I sum a range if the date is is greater than today's date? S2 Excel Worksheet Functions 4 October 8th 05 08:11 PM
in excel how do enter today's date on a laptop bency New Users to Excel 1 August 25th 05 12:39 AM
Setting today's date automatically in Excel. Ezlpo Excel Worksheet Functions 6 February 11th 05 02:27 PM


All times are GMT +1. The time now is 04:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"