Neveraliein
New Member
- Joined
- Jun 16, 2008
- Messages
- 2
This is really getting to me because I'm sure it's simple.
In Row 1 we have months mmm
In Column A there are various dates dd/mmm/yy
We, ultimately, want columns to total so we know occurences per month. IF A2 = date in jan it will return value of 1 in B2.
We tried (in B2) =IF(AND(A2>31/12/2007,A2<30/1/2008),1,0)
Bet someone has asked this before, but I haven't found anything in previous posts.
Any assistance would be appreciated
Thanks
In Row 1 we have months mmm
In Column A there are various dates dd/mmm/yy
We, ultimately, want columns to total so we know occurences per month. IF A2 = date in jan it will return value of 1 in B2.
We tried (in B2) =IF(AND(A2>31/12/2007,A2<30/1/2008),1,0)
Bet someone has asked this before, but I haven't found anything in previous posts.
Any assistance would be appreciated
Thanks