Making Excel 03 count product usage by month
 

Hello,
I need a way to track product usage by months in MS Excel 2003. I need to
enter the start date of a period, which could be in the middle of a month,
and the end date of the period, which could be any time about 190 days later.
I need to know the usage of the product per month. I know how much of the
product will be used each day, which will vary each day in the period. My
problem is that I need to be able to make excel start a new count of the
product and output it when the first of each month is reached in a given
period. Hopes that is enough info. Thanks!

Making Excel 03 count product usage by month
 

Why not just record the usage each day and then use sumif against your data

=sumif(A:A,"=Feb 15, 2007",B:B)-Sumif(A:A,"Aug 24, 2007",B:B)

--
Regards,
Tom Ogilvy


"Josh C" wrote:

Hello,
I need a way to track product usage by months in MS Excel 2003. I need to
enter the start date of a period, which could be in the middle of a month,
and the end date of the period, which could be any time about 190 days later.
I need to know the usage of the product per month. I know how much of the
product will be used each day, which will vary each day in the period. My
problem is that I need to be able to make excel start a new count of the
product and output it when the first of each month is reached in a given
period. Hopes that is enough info. Thanks!