View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default How do I set a static date?

See this:

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

--
Biff
Microsoft Excel MVP


"Shawn" wrote in message
...
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?