|
|
To advertise on these forums, e-mail us. |
|
|
Thread Tools | Search this Thread | Display Modes |
#1
|
|||
|
|||
Newletter Spreadsheet Solution
A = Amount
B = Start Date C = End Date To produce Liability in Column D =if ( today() < c1, a1*( c1 - today()) / (c1-b1), 0) |
#2
|
|||
|
|||
Thanks, JFC.
That's brilliant, exactly what we need. I might have to give you a call to help apply the equation but it looks simple. |
Thread Tools | Search this Thread |
Display Modes | |
|
|