Day of week goal changes

**arnorman** · 03-19-2014, 10:05 AM

Hello and thank everyone for any help that is provided.
My employees have at group goal of $30,000. We work Monday thru Friday, so that is 5 days. On Monday the goal would be divided by 5 days remaining, Tuesday divided by 4, and so on.
How do I make a formula so that every day the goal is divided by the correct number?
E43 is where I put my weekly goal
E44 is the current formula =SUM(E43/5). So that 5 in the formula needs to be a 4 on Tuesday and so on.

Thank you.

**Tony Valko** · 03-19-2014, 10:10 AM

Try this...

Entered in E44 and copied down to E48:

=E$43/ROWS(E44:E$48)

**Melvinrobb** · 03-19-2014, 10:10 AM

This formula should do it:

Formula:

Please Login or Register  to view this content.

**Tony Valko** · 03-19-2014, 10:17 AM

Originally Posted by Melvinrobb

This formula should do it:

=E43/(6-WEEKDAY(TODAY(),2))

I think I misunderstood what the OP wanted.

What about the weekend days? If today is Saturday you'll get an error.

**Melvinrobb** · 03-19-2014, 10:31 AM

The goal only applies to the 5 business days. After Friday, the goal should be met.
The formula below would now account for this possible Error scenario:

Formula:

Please Login or Register  to view this content.

**Tony Valko** · 03-19-2014, 10:33 AM

Ok, that'll work.

Day of week goal changes

LinkBack

Thread Tools

Rate This Thread

Display

Day of week goal changes

Re: Day of week goal changes

Re: Day of week goal changes

Re: Day of week goal changes

Re: Day of week goal changes

Re: Day of week goal changes

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] excel hlep to calculate the week no from dispatch to closed calls week wise

Chart previous week data as grouped and current week as ungrouped

How to: identify repeat offenders within a 3 week period (week per week basis)

Issues trying to solve for X using (goal seeking formula w/o using Goal Seek)

Goal Seek VBA with relative 'Goal' parameter

Bookmarks

Bookmarks

Posting Permissions