Cancel

Excel DateDif and Networkdays

Posted Jul 29, 2016 2016-07-29T00:00:00+08:00 by PipisCrew

DATEDIF is a hidden function in Excel. http://www.exceltrick.com/formulas_macros/excel-datedif-function/

use (to diff excluding weekend) :

//http://www.mrexcel.com/forum/excel-questions/335055-datedif-excluding-weekends.html
=NETWORKDAYS(A1,B1)

#excel

origin - http://www.pipiscrew.com/?p=5952 excel-datedif-and-networkdays

This post is licensed under CC BY 4.0 by the author.

Contents