Checking is Date is in This Month

[EdWoods]

Hi,

I'm entering dates in (say) Column A

In Column C I want a formula that returns 1 if the date in the Row is in this current month, or 0 if not.

Sounds simple, but I just can't make it work.

Thanks

(edit: Thread Title has a typo - "is" should be "if")

[humdingaling]

Please Login or Register  to view this content.

sorry just read MONTH =)

[EdWoods]

Please Login or Register  to view this content.

sorry just read MONTH =)

Sorry, not working for me

[Andy Pope]

one way

C1: =--AND(MONTH(A1)=MONTH(NOW()),YEAR(A1),YEAR(NOW()))

[JohnTopley]

Works fine for me.

[humdingaling]

umm not sure why its not working....do you have a sample file ?

[EdWoods]

one way

C1: =--AND(MONTH(A1)=MONTH(NOW()),YEAR(A1),YEAR(NOW()))

Done. Thanks

[EdWoods]

Works fine for me.

Think I did another typo (been a long day!)

[VKS]

Hi,

Please check if this helps

Please Login or Register  to view this content.

Best Regards/VKS