Thread: return the 2 diget year value
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
EngelseBoer EngelseBoer is offline
external usenet poster
  
Posts: 67
Default return the 2 diget year value
more correctly

1997-11-23
returns 97

"EngelseBoer" wrote:

how can i return the yy value of a date please

ie 1996 returns 96
Reply With QuoteReply With Quote