|
|
#4
03-01-2022, 07:26 AM
|
||||
|
||||
Formula in row 2:
Code:
=CHOOSE(MIN(MONTH($B2)-MONTH($A2)+1,2),INDEX($D2:$O2,MONTH($A2))*(DAY($B2)-DAY($A2)+1)/DAY(EOMONTH($A2,0)),INDEX($D2:$O2,MONTH($A2))*(1-(DAY($A2)-1)/DAY(EOMONTH($A2,0)))+INDEX($D2:$O2,MONTH($B2))*DAY($B2)/DAY(EOMONTH($B2,0))+IF(MONTH($B2)-MONTH($A2)>1,SUM(INDEX($D2:$O2,MONTH($A2)+1):INDEX($D2:$O2,MONTH($B2)-1)),0)) See attached. (Row 6 was my test row.) 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Return value base on two columns | yewee | Excel | 5 | 02-13-2017 03:16 AM |
| finding variations in the data base | adryan | Excel | 4 | 07-15-2015 12:19 AM |
 Creating small data Base
|
quintinros | Excel | 2 | 06-26-2014 12:28 AM |
| Calculate formula base of list menu | rkeles | Excel | 4 | 09-22-2010 12:38 AM |
| Calendar Base | prayojana | Project | 0 | 11-12-2007 01:13 AM |
Windows 10 
Office 2019
Threaded Mode