IFERROR and NETWORKDAY formula

vishal228

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

Kerry St. Thomas

NETWORKDAYS is a row-specific 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?