View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tim Elhatton Tim Elhatton is offline
external usenet poster
 
Posts: 8
Default Enter day, default month and year

Hi,
I would like a user to enter just the day in a cell and then display a fixed
month and year.
For example:
user enters 25
Date display will be January 25, 2008
I have a separate worksheet for each month, so 12 worksheets that will
default to corresponding month. They will all be the year 2008.
Thanks for any tips.