Thread: Year showing 1899 instead of 2009
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rick Rothstein Rick Rothstein is offline
external usenet poster
  
Posts: 5,934
Default Year showing 1899 instead of 2009
TODAY is a worksheet function, not a VB one. Use either one of these
instead...

? Year(Now)

? Year(Date)

--
Rick (MVP - Excel)


"Bob Zimski" wrote in message
...
How do I get the following to give me 2009 instead of 1899 in immediate
window?

? Year(today)
produces 1899 rather than 2009



Reply With QuoteReply With Quote