Killa'

If I understand you correctly and assuming that you have A1:D1 with your
headers, "Date, Production Amount, Weekly Goal and What It Will Take
Tomorrow" respectively. I further assume that as you quote every day of
the week Sunday to Saturday, you work Sunday to Saturday.

In A2 your formula: =TODAY()
In A3 enter: =IF(A2="","",IF(WEEKDAY(A2,1)<7,A2+1,"")) and copy it down to
A8 then custom format A2:A8 as "dddd mmm d yyyy" (without the quotes and
make sure that the column is wide enough to display a date like: "Saturday
September 30 2006"

In D2 enter: =ROUND((C2-B2)/(COUNT(A2:A8)-1),0)&" Per day"

If you only work Monday to Friday then in A3 use:

=IF(A2="","",IF(WEEKDAY(A2,3)<4,A2+1,"")) and copy it down


--
HTH

Sandy
In Perth, the ancient capital of Scotland


with @tiscali.co.uk


wrote in message
ups.com...
Ok, First I'm an Excel novice! I have a spreadsheet that has
'Production Amount', 'Weekly Goal', and 'What It Will Take Tomorrow'
columns. I also have two cells that displays the day of the week (ex.
Wednesday formula: =TODAY()) and the Month (ex. 6/21/06 Fornula:
=CHOOSE(WEEKDAY(H1),"Sunday","Monday","Tuesday","W ednesday","Thursday","Friday","Saturday")).
I want to be able to open that spreadsheet everyday and input the
production amount completed for that employee and have the spreadsheet
calculate what it will take on each of the following days of the week
to reach their goal. Right now i have it calculating entire goal
remaning in the 'What It Will Take Tomorrow' column. I would like
that column to consider the remainder of the days left in the week and
divide the goal by that number of days. Thanks for any help!

Killa'