Hi,
I have a column with dates Apr-Mar and want to be able to count how may fall with in the following quarters.
Apr-Jun
Jul-Sep
Oct-Dec
Jan-Mar
Dates will be in a random order and some cells may be blank until a date is entered etc.
I have a column with dates Apr-Mar and want to be able to count how may fall with in the following quarters.
Apr-Jun
Jul-Sep
Oct-Dec
Jan-Mar
Dates will be in a random order and some cells may be blank until a date is entered etc.
| A | B | C | |
| 1 | Date | Results | |
| 2 | 01/04/2024 | 3 (fall within Apr-Jun etc) | |
| 3 | 18/11/2024 | 2 (fall within Jul-Sep etc) | |
| 4 | 30/06/2024 | 4 (fall within Oct-Dec etc) | |
| 5 | 01/07/2024 | 1 (falls within Jan-Mar etc) | |
| 6 | |||
| 7 | 03/10/2024 | ||
| 8 | 08/10/2024 | ||
| 9 | 08/05/2024 | ||
| 10 | 29/12/2024 | ||
| 11 | 02/02/2025 | ||
| 12 | 30/09/2024 | ||
