Reply to thread

Message: [QUOTE="custo80, post: 760803, member: 31252"] If i've put this in the wrong area.......sorry Ill have to show an example of what I want to explain it properly Cell A1 =$100 Cell A2 = $110 My weekly targets run from Tuesdays until Mondays In cell 3 I’m after the following If today is Tuesday then cell 3 = A2-A1 / 7 days On Wednesday it becomes cell 3 = A2-A1 / 6 days And so on until the next week starts where I will continue down B1 & B2 with different values for those weeks. Is there a formula to put in A3 that will subtract A1 from A2 and divide it by the number of days left in the week? If this isn’t that clear please ask me Thanks [/QUOTE]