Dates + Macros

[DarkOwl]

Basically i have a problem, to which i cannot find a working solution.
I have a sheet with an invoice on, which has a date.
I am trying to get a macro which takes the value of the cell which has the date in, and detrmines what Month it is in, and pastes it in a Table, which has the Months down one column.
Basically i need to knw what funcions to use to sort dates in the form of dd/mm/yy into a table showing months

I cna change the formt the date is displayed in if needed or helpfull.
Thanks in advance

 

[jdc]

Hi

Why don't you copy the whole date over and format the cell to "mmmm" which will then display the month.
If the months need to be sorted irrespective of the year just create another column with the formula showing "=MONTH(a2)" where a2 is the full date.

HTH

John