View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default How do I set a static date?

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



--


Regards,


Peo Sjoblom




"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?