ALL BUSINESS ENGLISH ARTICLES MICROSOFT EXCEL TIPS

Count days between two dates

Calculate the days of work between two dates with the NETWORKDAYS function

Start Date: 15/5/2020

End Date: 28/1/2021

Holiday 1: 26/8/2020

Holiday 2: 18/11/2020

Holiday 3: 15/1/2021

Calculate the days between two dates with the NETWORKDAYS function excluding

Holiday 1, Holiday 2 and Holiday 3. Saturday and Sunday are omitted.

 

Result

Number of days between the two dates: 182

 

#softexperia #excel_tips

Views: 1

Comments are closed.

Pin It

By continuing to use the site, you agree to the use of cookies. / Συνεχίζοντας να χρησιμοποιείτε την ιστοσελίδα, συμφωνείτε με τη χρήση των cookies. more information / περισσότερες πληροφορίες

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close