This is possible if somewhere on your June 05 sheet you have a cell with
the specified month in a date format. e.g. cell A1 could contain 38504
(the value for June 1, 2005) and format as mm/yy to show Jun 05.

then this formula would work:

=IF(MONTH(Sheet1!F4)=MONTH(A1),Sheet1!F4,"")

adjust the name of Sheet1 to meet your needs

HTH

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=465719