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

Have a look at the NETWORKDAYS function

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Hi,

Still don't get it. Here i attached the spreadsheet.

If you see cell C6, its counting 7 inclusive of weekends. How can i exclude the weekends without messing up the current formula?

Please help

Attached Files

Testing.xls (39.0 KB, 13 views)

Try this:

=IF(ISBLANK(E6),TODAY()-B6,NETWORKDAYS(B6,E6,$F$6:$F$18))

Your formula =IF(ISBLANK(E6);TODAY()-B6;(E6-B6)) becomes

You have the option to add a range to the function, range containing the holidays.

Check the function's syntax to see how it works

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post