View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default Date not defaulting to current year

Which was it?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Tim Elhatton" wrote in message
...
Thanks Don....

"Don Guillett" wrote:

Your subject line said "CURRENT" year and your msg said 2008.
On my xl2003 if if type 11/16 I automatically get the CURRENT year.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Tim Elhatton" wrote in message
...
Hi there,
I would like a user to enter JUST the Day and Month....and the year
default
to 2008.
Does anyone have any ideas?