Keeping a date when today's date changes

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dps9460 - 03 Jun 2006 03:25 GMT

Can someone assist me with this. If I place a "Y" into column
(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 date
(Column 1) to stay. Can someone help. I'm having a rough time and I'
sure it's pretty simple.:rolleyes:

Today's Date

6/2/2006

Column 1 (Tested) Y    (Date) 6/1/2006
Column 2 (Tested) Y    (Date) 6/2/200

Reply to this Message

Peo Sjoblom - 03 Jun 2006 03:41 GMT

http://www.mcgimpsey.com/excel/timestamp.html

just change now to today

Signature

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

> 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.
[quoted text clipped - 8 lines]
> Column 1 (Tested) Y (Date) 6/1/2006
> Column 2 (Tested) Y (Date) 6/2/2006

Reply to this Message

dps9460 - 03 Jun 2006 04:25 GMT

:) :) :) 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

Signature

dps9460

Reply to this Message