- Jul 5, 2005
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!!