I have a large spreadsheet containing raw inventory data. The data has
inventory spanning calendar years (2005 - 2006). I need to account for 2006
inventory only. A sample of what my data looks like: 9,000,000 units sold
from 9/12/05 - 3/15/06. I need to write a formula that will evenly break out
the 2006 units into months (daily units x days in month). I can manually do
this for several lines, but I have thousands of lines of data. What formula
can I use to read the date range and evenly distribute the units across
months?

Thanks!

-TK

Have you tried adding filters?

"TK" wrote:

I have a large spreadsheet containing raw inventory data. The data has
inventory spanning calendar years (2005 - 2006). I need to account for 2006
inventory only. A sample of what my data looks like: 9,000,000 units sold
from 9/12/05 - 3/15/06. I need to write a formula that will evenly break out
the 2006 units into months (daily units x days in month). I can manually do
this for several lines, but I have thousands of lines of data. What formula
can I use to read the date range and evenly distribute the units across
months?

Thanks!

-TK