Calculate networkdays using vba .formula

[welchs101]

Hi,

I am trying to calculate the networkdays between two dates using vba. I am inserting a formula into the worksheet but for some reason the value i calculate is "0". When i do the calculation manually i get the right value.........any ideas.........see enclosed excel file.

[TMS]

I've always found that the easiest way to get a formula into VBA is to get it to work in the spreadsheet first ... which you have done.

So, select the cell with the working formula and start recording a macro. Press F2 to go into Edit mode and press Enter to re-confirm the formula. Stop the macro recording. You now have the code for the formula in the active cell. Modify that for the cell(s) you want and you're done. That will reproduce the formula and adjust the ranges automatically.

Regards, TMS

[excel-walker]

Please Login or Register  to view this content.

Keep it in double quotes. it will give you the right results.

Thanks

[TMS]

Please Login or Register  to view this content.

Or, with your code:

Please Login or Register  to view this content.

Regards, TMS