View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Neely Neely is offline
external usenet poster
 
Posts: 1
Default How to autopopulate column w/May using a col w/ 05/15/07(Excel)?

I have a worksheet that lists termination dates for employees. There are two
additional columns used in the worksheet that denotes the Month and Year of
termination. We would like to be able to autopopulate the Month and Year
columns using the date in the Termination column. As above, if the term date
is 5/15/07, the Month column would show May; the Year column would show 2007.
At this time we have to type in the Month and Year.