NETWORKDAYS Formula < =NETWORKDAYS(MAX({Range}), TODAY()) >

Christina246

=NETWORKDAYS(MAX({Range}), TODAY()) 

With the formula listed above I am attempting to find the difference in workdays between two dates. The MAX function is pulling the latest date from a column in another sheet. The TODAY function is referencing the current date.

If the date discovered with the MAX function is todays date (example: TODAY = June 27th and MAX = June 27th) will the NETWORKDAYS formula produce "0" or "1"? Currently, my formula produces 1, but I believe it should show 0.

Mike TV

@Christina246

To answer your question, the formula in your post would result in a returned value of 1 if the max date found was today's date. The formula is working as intended. If you do not want to count today as a day, then change your formula to:

=NETWORKDAYS(MAX({Range}), TODAY()) -1

Mike TV

@Christina246

To answer your question, the formula in your post would result in a returned value of 1 if the max date found was today's date. The formula is working as intended. If you do not want to count today as a day, then change your formula to:

=NETWORKDAYS(MAX({Range}), TODAY()) -1