I have a spreadsheet which has several headings including date (i.e. 11.01.2012) and Month (i.e Jan)
I was looking for a formula which will recognise a date and automatically fill in the "month" cell based on the date text entered. Is this possible?
The point of this is that i want to be able to filter info from different months and have this info copied into another tab.
PLEASE HELP!!
Bookmarks