Working Weeks

[Terry Bennett]

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 & Sun don't count.

Any ideas?

 

[Niek Otten]

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

Tools>Add-ins, check Analysis Toolpak

 

[Ron Rosenfeld]

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 & Sun don't count.

Any ideas?

=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

 

[Terry Bennett]

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?

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 & Sun don't count.

Any ideas?

=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

 

[Ron Rosenfeld]

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?

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

 

[Terry Bennett]

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