#### Luke.Speam

##### New Member

- Joined
- Jun 6, 2012

- Messages
- 6

I have been using a spreadsheet (Excel 2008 for Mac, OS X 10.6) to track how much I have spent using my debit card for some months now. One particular piece of information I would like to get from my spreadsheet is how many times I have been shopping each month. by 'been shopping', I mean on how many days have I spent money (occasionally I will go to two or three shops on the same day).

Thus, I have been trying to find a formula to count the number of days I have been shopping in a give month. For example:

A B

1 10/10/11 £x

2 15/10/11 £x

3 15/10/11 £x

4 25/10/11 £x

5 25/10/11 £x

6 30/10/11 £x

7 1/11/11 £x

8 5/11/11 £x

9 5/11/11 £x

10 12/11/11 £x

11 12/11/11 £x

12 12/11/11 £x

13 20/11/11 £x

14 25/11/11 £x

The £ values in column B don't matter. I would like to find some formula that can take the dates in A1:A14 and tell me that during the month of October I went shopping on 4 days, and during the month of November I went shopping on 5 days. Obviously, separate formulae for each month are necessary.

So far I have been able to count either the number of non-unique shopping trips (6 in October, 8 in November) or the total unique shopping trips, regardless of month (9 in total).

Any help would be appreciated, thank you.