If you want to check just for the month, this formula will give you always
the first day of the month for the given date:
=DATE(YEAR(A1),MONTH(A1),1)
You can build your lookup table, or sumif conditions, with that date.

Hope this helps,
Miguel.

"Brian Matlack" wrote:


Hi!
How can I convert a date like this 01/12/06 into one that looks like
this Jan-06 so that a sumif or lookup will get all dates that fall in
January of 2006. Formatting does not do it because the functions still
reads it as 01/12/06.
Any help or direction would be greatly appreciated!! Thanks!!


--
Brian Matlack
------------------------------------------------------------------------
Brian Matlack's Profile: http://www.excelforum.com/member.php...fo&userid=3508
View this thread: http://www.excelforum.com/showthread...hreadid=543470