Well as Mark has said without some more to go on it is tough to say anymore than it is done all the time.
Look up DAY, WEEKDAY, MONTH, YEAR .etc in the help section. with SUMIF or an array formula they will pull the data you require.
Month for example will allow you to select all the days of a month no matter when it start or how many days ar in the month.
HTH
Rocky...
This message was edited by Rocky E on 2002-04-22 11:30