Is NETWORKDAYS Supported in Excel to Web Page?

[PatrickA]

All,

When I save my Excel worksheet as a Web Page (with Spreadsheet
Interactivity), any cell where I am using the NETWORKDAYS function
(e.g. =(NETWORKDAYS(F9,F10)*G9)) returns the #NAME? error.

NETWORKDAYS is a formula supported by the Analysis Toolpack add-in.

What I need to know is how to get it supported in my (internal,
network hosted) web page.

I did install the Office 2003 Web Components.

Anyone got any mojo for this?

Thanks,

Patrick

 

[Shane Devenshire]

Hi,

The problem here is that NETWORKDAYS is an Analysis ToolPak function. I
don't thing the web published version can access these functions. You might
write a regular Excel function to calculate the same thing and then publish
that version.

A little note for the future - I believe that Excel 2007 does not support
interactive web page publishing.

 

[PatrickA]

Thanks Shane, I don't see a Yes button though.

For a formula to calculate workdays between 2 dates, does this sound
about right?

(Later Date minus Earlier Date) minus ((Later Date minus Earlier Date)
divided by 7) times 2
Days Difference minus 2 x weeks difference (to
account for 2 weekend days per week)


(1/31/09 - 1/1/09) - ((1/31/09 - 1/1/09)/7)*2
30 - (30/7)*2
30-(4.3*2)
30-8.6
21

Thanks again,

Patrick

 

[Shane Devenshire]

Don't worry about the Yes button that only show up if you are working
directly on the Microsoft Site.

Here is a formula which will calculate the number of workdays between two
date, where the start date is in F1 and the end date in G1, and you are not
considering holidays.

=SUMPRODUCT(--(MOD(ROW(INDIRECT("A"&F1&":A"&G1)),7)>1))

 

[PatrickA]

Shane,

Thanks for trying to help.

The formula

=SUMPRODUCT(--(MOD(ROW(INDIRECT("A"&F1&":A"&G1)),7)>1))

gives me the dreaded #REF! error...

Patrick

 

[chris]

An alternative to save as Web Page (with Spreadsheet Interactivity) is
to use SpreadsheetConverter.

http://www.spreadsheetconverter.com/excel-html-web.htm

The advantage is that the web page will work for any browser on any
OS, not just for those who have Microsoft Office installed.

Regards,

Chris