Thread: How do I set a static date?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default How do I set a static date?
You could also hit the ctrl-; shortcut combination to get the date.

Shawn wrote:

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?

--

Dave Peterson
Reply With QuoteReply With Quote