# Can I calculate how many days have been done?

#### Nybbe

##### New Member
I have two columns, one with planned start date and the next with planned end date. Is it possible to create a formula that calculates the average progression in procent?
I want to calculate the progression in procent per line (0-100%), and then calculate the average of these procents.
I can make it by adding an extra column, with the formula
=IF(TODAY()<G6,0,IF(TODAY()>H6,1,(TODAY()-G6)/(H6-G6)))
(column G is startdate and column H is enddate).
I can then get the average of this new column.

But is it possible to do this in one formula?
I tried this CSE-formula which is basicly the same as above, but with average around and entered with Ctrl+Shift+Enter. It does does not give me the correct result though:
=AVERAGE(IF(TODAY()<(Activities!\$G\$6:\$G\$500),0,IF(TODAY()>(Activities!\$H\$6:\$H\$500),1,(TODAY()-(Activities!\$G\$6:\$G\$500))/((Activities!\$H\$6:\$H\$500)-(Activities!\$G\$6:\$G\$500)))))

I am running excel 97.

### Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

#### s-o-s

##### Active Member
Hi Nybbe,

I have slightly amended your array formula but this works see formula below in I18.

Hope this helps.
Book1
GHIJ
1StartEnd%Complete
201/08/0231/08/0273%
302/08/0231/08/0272%
403/08/0231/08/0271%
504/08/0231/08/0270%
605/08/0231/08/0269%
706/08/0231/08/0268%
807/08/0220/08/02100%
908/08/0220/08/02100%
1009/08/0220/08/02100%
1110/08/0220/08/02100%
1211/08/0231/08/0260%
1312/08/0231/08/0258%
1413/08/0231/08/0256%
1514/08/0231/08/0253%
16
17CheckUsingColumn75.08%
18UsingArrayFormula75.08%
Sheet2

Replies
0
Views
129
Replies
6
Views
452
Replies
6
Views
448
Replies
3
Views
218
Replies
6
Views
354

1,195,598
Messages
6,010,647
Members
441,558
Latest member
lambierules

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back