ExcelBanter - The number 28232 result when using NETWORKDAYS function

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - The number 28232 result when using NETWORKDAYS function (https://www.excelbanter.com/excel-worksheet-functions/180530-number-28232-result-when-using-networkdays-function.html)

seymourgomez

The number 28232 result when using NETWORKDAYS function

If the applicable beginning date cell is blank, I get the number 28232
result. How do I get rid of it?

Dave Peterson

The number 28232 result when using NETWORKDAYS function

=if(count(a1,c9)<2,"Missing a date",yourformulahere)

Change A1 and C9 to the cells you're looking at.

seymourgomez wrote:

If the applicable beginning date cell is blank, I get the number 28232
result. How do I get rid of it?

--

Dave Peterson

All times are GMT +1. The time now is 07:19 AM.