Counting Problem

[treeboy_steve]

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!

 

[Aladin Akyurek]

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]

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.