Thread: Date formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Stephen[_2_] Stephen[_2_] is offline
external usenet poster
 
Posts: 364
Default Date formula

"Scott@CW" wrote in message
...
In column C I have a list of dates (8/16/2007), I want to right a formula
in
column A that would return just the month and year (OCT07). Is this
possible?


A1 could just contain
=C1
and be formatted as MMM YY