Comparing Months with Current

[pattersong]

I've been trying to workout a formula using the if command compairing a date column (A1) to the current month. This is what I have come up with, but it is not working out correctly. =IF(A1=MONTH(TODAY()),"true","false") A1=4/6/2011. It returns a false. I hope I explained it correctly. Any help you can provide would be great!!

 

[VoG]

Try

=IF(MONTH(A1)=MONTH(TODAY()),"true","false")

 

[T. Valko]

I've been trying to workout a formula using the if command compairing a date column (A1) to the current month. This is what I have come up with, but it is not working out correctly. =IF(A1=MONTH(TODAY()),"true","false") A1=4/6/2011. It returns a false. I hope I explained it correctly. Any help you can provide would be great!!

Try something like this...

=MONTH(A1)=MONTH(NOW())