ok buddy, check your email. But I have shown only one example and it follows the condition rascal mentioned. If there is different condition, you can put additional logical conditions. For description, follow above writings. Let me paste for you so that you can give a glance at once => Considering 7 working days and each day worths equal amount, here is one example. For the date cell, click format and click date. For amount , click format and click number. Current Sheet January 1/12/2007 3/25/2007 3500.00 732.22 1/25/2007 3/20/2007 2500.00 769.11 1/5/2007 2/20/2007 2200.00 744.09 Sheet 2 January February March 1/31/2007 02/31/07 3/31/2007 732.22 is E5 ; 1/31/05 is D5 in sheet 2 and I used this formula =((B5-C5)/D5)*(Sheet1!D5-B5) With the reference E5 for current sheet and D5 for sheet 2, all the there is no blank cell between consecutive rows and columns.