I would use a dummy column with a formula that identifies the month and then
use that column for filtering on month.

alternatively, if you use the custom function, you can bracket the month

= first of the month
and
<= End of the month

--
Regards,
Tom Ogilvy


"spartikus411" wrote:


trying to keep it up at the top


--
spartikus411
------------------------------------------------------------------------
spartikus411's Profile: http://www.excelforum.com/member.php...o&userid=34933
View this thread: http://www.excelforum.com/showthread...hreadid=546666