software

I need to calculate the number of working weeks that have accumulated at any
given date.

Obviously, TODAY()-the start date / 7 will give an approximate result, but I
really want to just count weekdays. So, Weds = 0.6, Thurs = 0.8, Fri = 1.0
but then Sat amp; Sun don't count.

Any ideas?
Look in HELP for the Networkdays() function.
If the function returns #NAME:

Toolsgt;Add-ins, check Analysis Toolpak

--
Kind regards,

Niek Otten

quot;Terry Bennettquot; gt; wrote in message
...
gt;I need to calculate the number of working weeks that have accumulated at
gt;any given date.
gt;
gt; Obviously, TODAY()-the start date / 7 will give an approximate result, but
gt; I really want to just count weekdays. So, Weds = 0.6, Thurs = 0.8, Fri =
gt; 1.0 but then Sat amp; Sun don't count.
gt;
gt; Any ideas?
gt;
On Mon, 9 Jan 2006 16:50:25 -0000, quot;Terry Bennettquot; gt;
wrote:

gt;I need to calculate the number of working weeks that have accumulated at any
gt;given date.
gt;
gt;Obviously, TODAY()-the start date / 7 will give an approximate result, but I
gt;really want to just count weekdays. So, Weds = 0.6, Thurs = 0.8, Fri = 1.0
gt;but then Sat amp; Sun don't count.
gt;
gt;Any ideas?
gt;

=NETWORKDAYS(start_date,end_date,[holidays]) / 5

See HELP for NETWORKDAYS. If you get a #NAME error, HELP will tell you how to
install the Analysis ToolPak.

Holidays is an OPTIONAL list of holiday dates.--ron

Thanks for the suggestion.

My own (modern) laptop has this add-in but as the spreadsheet will be used
by a number of people running Excel 95, I wonder whether it will be
available?

quot;Ron Rosenfeldquot; gt; wrote in message
...
gt; On Mon, 9 Jan 2006 16:50:25 -0000, quot;Terry Bennettquot;
gt; gt;
gt; wrote:
gt;
gt;gt;I need to calculate the number of working weeks that have accumulated at
gt;gt;any
gt;gt;given date.
gt;gt;
gt;gt;Obviously, TODAY()-the start date / 7 will give an approximate result, but
gt;gt;I
gt;gt;really want to just count weekdays. So, Weds = 0.6, Thurs = 0.8, Fri =
gt;gt;1.0
gt;gt;but then Sat amp; Sun don't count.
gt;gt;
gt;gt;Any ideas?
gt;gt;
gt;
gt; =NETWORKDAYS(start_date,end_date,[holidays]) / 5
gt;
gt; See HELP for NETWORKDAYS. If you get a #NAME error, HELP will tell you
gt; how to
gt; install the Analysis ToolPak.
gt;
gt; Holidays is an OPTIONAL list of holiday dates.
gt;
gt;
gt; --ron
On Mon, 9 Jan 2006 23:40:43 -0000, quot;Terry Bennettquot; gt;
wrote:

gt;Thanks for the suggestion.
gt;
gt;My own (modern) laptop has this add-in but as the spreadsheet will be used
gt;by a number of people running Excel 95, I wonder whether it will be
gt;available?
gt;

NETWORKDAYS was available at least as far back as Excel 4.0 (1992) (in the
Analysis Tool Pak, then, too). It's listed in documentation I have from that
release. So I'm sure it would have been available in Excel 95.

Is it a problem for them to use the Microsoft supplied add-in? If so, there
have been formula solutions posted in these NG's that I'm sure can be located
with a search.--ron

Thanks Ros - I think I've solved it in another (less sophisticated!) way.

quot;Ron Rosenfeldquot; gt; wrote in message
...
gt; On Mon, 9 Jan 2006 23:40:43 -0000, quot;Terry Bennettquot;
gt; gt;
gt; wrote:
gt;
gt;gt;Thanks for the suggestion.
gt;gt;
gt;gt;My own (modern) laptop has this add-in but as the spreadsheet will be used
gt;gt;by a number of people running Excel 95, I wonder whether it will be
gt;gt;available?
gt;gt;
gt;
gt; NETWORKDAYS was available at least as far back as Excel 4.0 (1992) (in the
gt; Analysis Tool Pak, then, too). It's listed in documentation I have from
gt; that
gt; release. So I'm sure it would have been available in Excel 95.
gt;
gt; Is it a problem for them to use the Microsoft supplied add-in? If so,
gt; there
gt; have been formula solutions posted in these NG's that I'm sure can be
gt; located
gt; with a search.
gt;
gt;
gt; --ron