How to get duration time excluding weekend

[#1]

Hi,

Can someone help me on how will I get the duration time from transmittal date to clearing date excluding weekends? Sample data provided below

Thank you so much!

Ahyel

[#2]

Ahyel,

The networkdays() function should suit you.

it accepts two arguments: first date, last date

Fabrice