How do I get the first entry for each month from a date field?

[#1]

My title probably isn't descriptive enough. There are a couple of reports run every month, and that data is dumped into a spreadsheet. That data has a date, model number, a "backlog count," and other fields. I need to make a chart that graphs that month's starting backlog total.

I'm sure it's something simple, and I'll hate myself once I get the answer, but my google-fu has failed me.

Thank you

[#2]

Thank you! I've been beating my head against a wall for three weeks trying to get this to work properly and this works!

[vishsaggi]

It took my head away as well, but made us think little more on it. I am glad it worked.