Here is the background to my question. We are uploading field data about various moth species caught by trap. These traps are checked every month, but not always on the same day of the month.The columns are date, trap number and total moths caught. I would like to use a calculated column to show the total moths caught for each month.
Once I have the correct formula from my moth data list I can then quite easily chart it by total moths caught by month.
I know the formula would have to have YEAR and MONTH otherwise I would be adding January 2012 and January 2013 etc.
Can anyone help?