date

  • Thread starter Thread starter Aaron
  • Start date Start date
A

Aaron

Is there a way to have excel populate the current date
such as =today() or =now() but make it so the next time
you open the workbook the original date is still there.
Using today and now puts whatever date it currently is. I
need to keep the date constant...Kinda lika a creation date


any help?

thanks
 
Aaron, you can use Ctrl+; to put in the date, or if you need a macro use
something like this

Sub test()
[A1] = Date
End Sub

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **
 
Aaron

I don't know of a function to do that. A shortcut, however, is Ctrl : (that
is hold Ctrl and press semi-colon). I have seen a posting (I think it was
from Peo) a few days ago with a formula that does what you want (I think)
but I can't find it!!

Andy.
 
I assume you mean something like this

=IF(A1="","",IF(B1="",NOW(),B1))

that is a time stamp for an entry in A1, tools>options>calculation and
check iteration or else you'll get a circular ref error
 
this is a macro im assumming, so would it look like

private sub workbook_open()
[a1] = date
end sub

im not sure what the test() is.
can you offer any further help?
-----Original Message-----
Aaron, you can use Ctrl+; to put in the date, or if you need a macro use
something like this

Sub test()
[A1] = Date
End Sub

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **

Is there a way to have excel populate the current date
such as =today() or =now() but make it so the next time
you open the workbook the original date is still there.
Using today and now puts whatever date it currently is. I
need to keep the date constant...Kinda lika a creation date


any help?

thanks
Click to expand...


.
Click to expand...
 
I knew you wouldn't resist!! <g>

Andy.

Peo Sjoblom said:
I assume you mean something like this

=IF(A1="","",IF(B1="",NOW(),B1))

that is a time stamp for an entry in A1, tools>options>calculation and
check iteration or else you'll get a circular ref error



--

Regards,

Peo Sjoblom
Click to expand...
 
ok I tried the VBA code and it works!!! thanks. So if any
one else askes its just as you say
private sub aaaa()
[a1] = date
end sub

thanks again

aaron
-----Original Message-----
Aaron, you can use Ctrl+; to put in the date, or if you need a macro use
something like this

Sub test()
[A1] = Date
End Sub

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **

Is there a way to have excel populate the current date
such as =today() or =now() but make it so the next time
you open the workbook the original date is still there.
Using today and now puts whatever date it currently is. I
need to keep the date constant...Kinda lika a creation date


any help?

thanks
Click to expand...


.
Click to expand...
 
Back
Top