Thread: Excluding weekends from a date range

I have attached a file I am working on where I need to exclude weekends from some procesing times in a worksheet, but not others. I tried working with the NETWORKDAYS function, but the 'logic' behind that is different to what I am trying to do. Any help would be appreciated!

Thanks

Tim

Hi Timjor,

Your data table is little confusing to me... do you want to have column D to have the dates as in column E.. then two dates are in Red in column E and the E4 and E5 have formulas and rest does'n't?

Regards,
DILIPandey

<click on below 'star' if this helps>