This did indeed help. Thank you very much for the quick responce.
swatsp0p wrote:
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
--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200509/1