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

Options

=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.

Best Answer

  • Mike TV
    Mike TV ✭✭✭✭✭✭
    Answer ✓
    Options

    @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

Answers

  • Mike TV
    Mike TV ✭✭✭✭✭✭
    Answer ✓
    Options

    @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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!