Calculate running target by days in the month
 

I have a sheet that will list each day of the month as well as totals for
several categories for each day. I also have an end-month goal. I want to
show what each number should be at for any given day, but I want to make sure
that it's accurate (ie, whether the month has 28, 30 or 31 days).

For example, let's say a target goal is $3,000. Over 30 days that would be
$100 per day. But for a month with more or less than 30 days, I want the
formula to remain accurate without having to redo the formula every month.
Basically what I want to do is divide the goal by the days in the month, then
give a running rate to match against their actual performance.

Robert,

Say that A1 = 2/23/2005
and B1 = 3000

=B1/DAY(EOMONTH(A1,0))


=107.1428571



Don Pistulka


"Robert" wrote in message
...
I have a sheet that will list each day of the month as well as totals for
several categories for each day. I also have an end-month goal. I want
to
show what each number should be at for any given day, but I want to make
sure
that it's accurate (ie, whether the month has 28, 30 or 31 days).

For example, let's say a target goal is $3,000. Over 30 days that would
be
$100 per day. But for a month with more or less than 30 days, I want the
formula to remain accurate without having to redo the formula every month.
Basically what I want to do is divide the goal by the days in the month,
then
give a running rate to match against their actual performance.

Thanks, that answers my question just enough that I can do the rest myself.
Just the way I like it ;)

"Don" wrote:

Robert,

Say that A1 = 2/23/2005
and B1 = 3000

=B1/DAY(EOMONTH(A1,0))


=107.1428571



Don Pistulka


"Robert" wrote in message
...
I have a sheet that will list each day of the month as well as totals for
several categories for each day. I also have an end-month goal. I want
to
show what each number should be at for any given day, but I want to make
sure
that it's accurate (ie, whether the month has 28, 30 or 31 days).

For example, let's say a target goal is $3,000. Over 30 days that would
be
$100 per day. But for a month with more or less than 30 days, I want the
formula to remain accurate without having to redo the formula every month.
Basically what I want to do is divide the goal by the days in the month,
then
give a running rate to match against their actual performance.