Dates in IF Function ?

[Neveraliein]

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

 

[Gerald Higgins]

Hi N. . . and welcome to the board.

Perhaps try

=if(and(a2>date(2007,12,31),a2< date(2008,1,30)),1,0)<DATE(2008,1,30)),1,0)< p>

 

[barry houdini]

Rather than testing each date separately you could use one formula that will count how many dates are in each month, e.g.

=SUMPRODUCT(--(TEXT(A2:A100,"mmm-yy")="jan-08"))

will count how many dates in A2:A100 fall in January 2008

 

[Neveraliein]

Fantastic help, thanks. Both solutions are really useful