I guess I don't understand the point.

If you want to filter by a date (not a specific month), then you could use that
tip from Stephen Bullen that Ron shared with me.

If you want to filter by a month, you could filter = the first of the month you
want and < the first of the next month.

bpotter wrote:

My formula is =IF(L17=1,N17+L17*30.42)
Which gives me the date format of December-07. It takes the date of a
changeout and multipliesit by the amount of months that we need to
change it out. I am trying to create an order form that tells me when
to change the equipment out. Thanks for the help.

--

Dave Peterson