Thread: [Solved] Adding Formula
View Single Post
 
Old 12-09-2015, 06:20 PM
Azleenda Azleenda is offline Windows 7 64bit Office 2007
Novice
 
Join Date: Nov 2015
Posts: 4
Azleenda is on a distinguished road
Default Adding Formula

Hi,

I have this formula which helps to count the no.of days, but i notice it includes the weekends & holidays.

How do i exclude the weekends & holidays to my current formula?

=IF(ISBLANK(AG123),TODAY()-AD123,(AG123-AD123))

Thanks in Advance
Reply With Quote