Count working days between two Dates

Tanveer Rafique

New Member
Joined
Apr 23, 2019
Messages
2
Hi Mr Excel,

Good afternoon!

First of all i would like to thank you for your uploaded video on you tube.i have learnt a lot having watched them.
i was know nothing about excel,but your videos lot helped me to understand excel from basic to advance level.
i was normal labor in company of Alshaya in Kuwait,but having watched your uploaded excel videos and tricks those really helped me.Now i have become Administrator in that company and i am working in reporting TM, still i am following your new videos and try to learn new things.




<colgroup><col><col></colgroup><tbody>
</tbody>
 

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

tyija1995

Well-known Member
Joined
Feb 26, 2019
Messages
781
Office Version
  1. 365
Platform
  1. Windows
Hey,

Welcome to the forums!

I would use the NETWORKDAYS.INTL function for this.
First input is the start date, second input is the end date, third input is the weekend days (Excel will prompt you for this) and the fourth input are any holidays (e.g. bank holidays etc)
To use the 4th parameter, it would be best to pre-define any holiday dates in some cells and reference those in the function.
 

Tanveer Rafique

New Member
Joined
Apr 23, 2019
Messages
2
Hi,

Thanks for your quick replied!

i have done this its work, but challenge is when we don't have second date mean closing date in that case even i have tried use today function in order to get No of days but showing error.

So,here i want that days should be count even there is no closing date and that also excluded Fri & holidays.

Is there any way?

Your quick response will be Appreciated.
 

tyija1995

Well-known Member
Joined
Feb 26, 2019
Messages
781
Office Version
  1. 365
Platform
  1. Windows
Hey,

Using Today as the End date should still work, remember that you need opening and closing parenthesis after calling TODAY, so you would call it as TODAY().

As the End Date is required this function will error if you do not include some end date, the best you can do is use TODAY if you do not have a specific end date.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,151,821
Messages
5,766,641
Members
425,365
Latest member
MrLupin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top