IFERROR and NETWORKDAY formula
Hi,
I have a source sheet with two date columns: Date of Request and Date of Completion. I am using a summary sheet to create a dashboard and have used this column formula to cross reference the source sheet to find the number of working days between the two dates:
=IFERROR(NETWORKDAYS([SourcesheetRange1], [SourcesheetRange2]), "").
However, the formula only returns a blank field even for rows in the source sheet where both columns have dates.
The referenced columns are restricted to date values only. Some cells in the source columns are blank, hence the use of iferror.
Any help would be appreciated
Answers

NETWORKDAYS is a rowspecific formula, and not a range formula. In other words, it appears the formula you are using essentially is asking to look at two entire columns, and give ONE answer on how many days are between them  since there's not one unique answer, it evaluates to an error  hence the blank. You need to somehow constrain to a single row to get what you're trying to do. If it was on one sheet, I'd say something like =IFERROR(NETWORKDAYS(RequestDate@row, CompletionDate@row),"") would give you what it appears you're after  but since you're rolling this over to a summary, I'm not sure what you're trying to achieve. Are you able to provide screenshots including your column headers for a bit of additional context?
If this answer resolves your question, please help the Community by marking it as an accepted answer. I'd also be grateful for your response  "Insightful"or "Awesome" reactions are much appreciated. Thanks!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.8K Get Help
 406 Global Discussions
 218 Industry Talk
 457 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 297 Events
 37 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!