Home / Tricks / Working days between two dates
// trick 044 · Dates

Working days between two dates

The formula to copy, for Excel with Italian function names and for Google Sheets.

The formula

EXCEL (ITALIAN)=GIORNI.LAVORATIVI.TOT.INTL(A2;B2;1;Festività!A:A)
GOOGLE SHEETS=NETWORKDAYS.INTL(A2;B2;1;Festività!A:A)
// this trick is already inside

2027 Leave and Attendance

Team holidays and leave, with 2027 public holidays and working days counted.

See the template