I am trying to create a filter for the current month data for an excel report I am creating. When I set the filter to "May" it will pull out all the May data. Though I want to set tit as current month so I don't have to go in and change it. I tried =Month(now()) but that isn't working. Not sure what I should be doing.
