How to calculation no. of days (only working days) between two dat
 

I have two date in date format, when I minus the two I can get the no. of
days. Any solution to exclude sat and sun, so only working days is counted?

How to calculation no. of days (only working days) between two dat
 

Hi,

Check out networkdays

=NETWORKDAYS(A1,B1)

Where A1 is the earlier date. The formula can also take a 3rd argument for
holidays so look at help.

Mike

"Vivian Chan" wrote:

I have two date in date format, when I minus the two I can get the no. of
days. Any solution to exclude sat and sun, so only working days is counted?