How do I set a static date?

[Shawn]

In A1 I'm putting an Id number in and I would like to set a formula in B2 so
that a static date appears, can this be done?

 

[Peo Sjoblom]

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



--


Regards,


Peo Sjoblom

 

[T. Valko]

See this:

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

 

[Dave Peterson]

You could also hit the ctrl-; shortcut combination to get the date.

 

[Peo Sjoblom]

It's in that link


--


Regards,


Peo Sjoblom

 

[Dave Peterson]

Yes, it is!

It's in that link

--

Regards,

Peo Sjoblom