Thread: Excel Jululian
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
George A. Jululian[_2_] George A. Jululian[_2_] is offline
external usenet poster
 
Posts: 89
Default Excel Jululian

Hi
I need your help on this formula
I need to calculate Storage Fees
Column (A) Date In
Column (B) Date out
Column (C) numbers of days in Stock (A1-B1)=112days
The First ten days free
The fees on First 20 days after the 10days = 1 dollar
The fees on second 20 days after the 10days and 20 day = 2 dollar
The fees on Third 20 days after the 10days,20day and 20day = 3 dollar
The fees on remaining days after the 10days, 20day, 20day, and 20 day = 10
dollar


Date In Date out Numbers of days

05/11/2008 25/02/2009 112


Regards