# Counting Problem

#### treeboy_steve

##### New Member
Hi.

I need help.

Basically what I need to do is add up the days remaining, i.e not including those from the months that have passed.

So, using the example below,

August September October November December Total

7 8 3 6 5 29

The number of days remaining for this is 14 (Oct, Nov & Dec).

Hope this makes sense!

### Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

##### MrExcel MVP
Hi.

I need help.

Basically what I need to do is add up the days remaining, i.e not including those from the months that have passed.

So, using the example below,

August September October November December Total

7 8 3 6 5 29

The number of days remaining for this is 14 (Oct, Nov & Dec).

Hope this makes sense!

A1:

1-Aug-06

B1, copied across to E1:

=EDATE(A1,1)

F2:

=SUMIF(\$A\$1:\$E\$1,">="&(TODAY()-DAY(TODAY())+1),A2:E2)

#### treeboy_steve

##### New Member
It works, brilliant!

Is there a way I can enable the total days left to calculate the number of working days left (i.e not Saturday and Sunday)?

Thank you.

Replies
7
Views
119
Replies
1
Views
74
Replies
6
Views
49
Replies
1
Views
97
Replies
10
Views
89