Thread: Newletter Spreadsheet Solution
View Single Post
  #1  
Old 28th June 2006, 09:27 PM
jfc jfc is offline
Member
  
Join Date: Jan 1970
Location: Sydney
Posts: 402
Default 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)
Reply With Quote