Wed 12 Oct 2022, 16:45Delegate Sophie said...
Sophie has attended:
TD Intermediate Plus course
Count function
I would like to count the total number of cells that contain each month from a date format
Thu 13 Oct 2022, 08:55Trainer Marius said...
RE: count function
Hi Sophie,
Thank you for your question. The simplest way to do this would be to insert a column which shows the month from a date as a number.
The function is: =MONTH(B2) - if the dates are in column B. It will show 1 for Jan, 2 for Feb, etc.
In another column, write a COUNTIF function to count the number of e.g., Feb's (2s).
=COUNTIF(C:C,2) - Column C has the =MONTH functions.
I hope this helps!
Kind regards
Marius Barnard
STL
