Help with an excel formula

[custo80]

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

 

[benevg]

things would have been so much simpler if you used saturdays as your starting point :-/

try this formula:
=(A2-A1)/IF(10-MOD(TODAY();7)>7;10-MOD(TODAY();7)-7;10-MOD(TODAY();7))

you would need to format the cell (format menu -> cells -> number tab) with the formula to a number in case anything out of order seems to show up.

good luck!
-georgi

 

[Rounder_D]

(A2-A1)/input either 7,6,5,4,3,2,1

That should work if not, reply with more info about what you are trying to actually accomplish, because their are plenty of already made spreadsheets.