How to autopopulate column w/May using a col w/ 05/15/07(Excel)?

[Neely]

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.

 

[Trevor Shuttleworth]

If the termination date is in cell E2, for example, in F2 and G2 put the
formula: =E2

then format the cell F2 as Custom Type: mmm or mmmm (for the full month
name)
and format the cell G2 as Custom Type: yyy

Regards

Trevor