if statement

[rduke]

I have a spreadsheet that records the date of when an event happens. I have another spreadsheet that I want to count when an event happens in the month of April.

I tried this and it gives me a result of 1 even if the the event happen before the month in question.

=IF('[Delivery Redelivery Databse HGN.xls]DEL'!$I1083>31/3/2011,1,0)

This formula returns a valve of 1 even if the cell that contains the information is not greater than the date in the formula.

 

[rduke]

Thank you

 

[T. Valko]

Thank you

You're welcome!