Counting Problem

treeboy_steve

New Member
Joined
Oct 26, 2006
Messages
3
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!
 

Some videos you may like

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

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,192
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
Joined
Oct 26, 2006
Messages
3
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,518
Messages
5,529,314
Members
409,862
Latest member
lbisacca
Top