Can someone please tell me where I am going wrong with the formula in cell
K46.

I have the following in a spreadsheet :-

J K L M
43 01-May-2005 31 Sunday Date/Days Left in Month/Months
44 245 35.000 8.000 No. Days/weeks/Months Left
45 0.596 4.171 18.250 Target No. per Day/Week/Month
46 0.596 18.473 Target No. This Week/Month

The relevant formulas are as follows :-

J43
=IF(TODAY()>=DATE(2005,6,1),"",IF(TODAY()<DATE(2005,5,1),DATE(2005,5,1),TODA
Y()))

L43 =J43

This is formatted as dddd to produce the day of the week.

J45 =IF(J43="","",IF('Input List-Year Summary'!K41<0,ABS('Input
List-Year Summary'!K41)/J44,('Input List-Year Summary'!K41-(2*'Input
List-Year Summary'!K41))/J44))

The number in 'Input List-Year Summary'!K41 is -146 in this instance.

K46
=IF(L43="Sunday",7*J45,IF(L43="Monday",6*J45,IF(L43="Tuesday",5*J45,IF(L43="
Wednesday",4*J45,IF(L43="Thursday",3*J45,IF(L43="Friday",2*J45,J45))))))

What I want the formula in K46 to do is to count the days left in the
current week ( week commencing on a Sunday) if today's date is in May and if
today is earlier that 01-May-2005 the days left in the week commencing
Sunday from 01-May-2005. I have obviously got the formula or format wrong
because the formula says that L43 does not equal Sunday even though that is
what is displayed in L43.
The answer in this instance should be 4.171
--
John Bedford
Delete extra @ to reply.