I am getting #Name? in the Excel file which was created using a macro in Business Objects. The cell in question has a formula =NETWORKDAYS(B2,D2). The formula gets resolved when I double click on the cell.
Can someone please help me so that I get the value of formula instead of #Name? Any alternate solution to calculate cycle time between twp dates excluding weekend is also welcome.
Thanks & Regards,
Dinesh.
Dinesh (BOB member since 2002-08-22)
To calculate the difference between two dates (in days) excluding weekends using formulas in Business Objects Reporter: see this post.
The best solution would be to handle this on the universe and database side:
If your developer team could implement a calendar table on the database side (and your universe designer makes the appropriate changes such as including the calendar table, joining it properly, creating a universe object “Nbr of days between”, etc.) you could calculate even days between two dates excluding weekends and any company holidays.
Andreas 
(BOB member since 2002-06-20)
As Andreas says, handling this on the database side is usually better. Only if the database/universe side can’t provide the solution should you consider a reporting solution and then after that a VBA solution. Adding a VBA solution limits the number of BO people who can deal with any issues - not all BO people necessarily have VBA skills, whereas any good BO person should be able to fix most Universe/Reporter problems.
You could even build a pre-defined condition to determine when to count bank holidays, national holidays etc.
The first table to consider in reporting should always be your calendar table (at least the first of the dimension tables!)