asked on 3/9/2017

Distribute Values over date range (2 of 2)

Shums,

I have attached the excel. Please refer to my comment. I think its better than explaining. Feel free to ask any questions.

I had this question after viewing Distribute Values over date range.
EEspread_v3a.xlsx

Microsoft Excel Microsoft Office

Last Comment

pdvsa

3/9/2017

ASKER CERTIFIED SOLUTION

Shums Faruk

3/9/2017

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

pdvsa

3/9/2017

ASKER

Shums, that's really good. I have one tweak request: instead of referring to the cell that has the day count, can the formula count within the formula itself? the file I am working with does not have a row for day count and I can not modify it with such day count. Sorry about that.

Shums Faruk

3/9/2017

When I started, I was within the date range, but then the formula will be too long. That's why I added one more row.

Shums Faruk

3/9/2017

If you see closely, I am dividing the value with the count (row), which also I am indexing between date range. If I had to add count between the dates, I have to index all the count, which means, current formula will be 8 times longer.

pdvsa

3/9/2017

ASKER

ouch. OK understood. I can manage it. thank you for the help!