So far I know Carton Brewing in NJ does Sunday tours/tastings and I know Brooklyn does some things on Sundays and when they have special events they're usually monday. I'd love to know of any other breweries up to 2 hours from NYC that have something going on Sunday or Monday. Brew pubs worth visiting would be cool too.
Two Roads in Stratford, CT is open Sunday and Monday. That easily sneaks in your 2 hour range via train. Car would be likely under 2 hours as well depending on 95 traffic. New England Brewing is open Monday but that's probably just outside of 2 hours.
Trap Rock: http://traprockrestaurant.net/contact.html Ship Inn: http://www.britishbrewpub.com/ Both great brewpubs with great food.
It's a little outside of 2 hours from NYC but Cape May Brewing Co. just started doing Sunday tours (open 12-8pm) - http://www.facebook.com/CapeMayBrewCo/posts/404626299622318