Calculate difference between two dates excluding weekends in python?

Question

I want to create function which return me the difference between two dates excluding weekends and holidays ?

Eg:- Difference between 01/07/2019 and 08/07/2019 should return me 5 days excluding (weekend on 6/7/107 and 7/07/2019).

What should be best possible way to achieve this ???

score 9 · Accepted Answer · edited Jun 20 '20 at 09:12

9

Try converting string into date using the format of your date using pd.to_datetime()

use np.busday_count to find difference between days excluding the weekends

import pandas as pd
import numpy as np

date1 = "01/07/2019"
date2 = "08/07/2019"

date1 = pd.to_datetime(date1,format="%d/%m/%Y").date()
date2 = pd.to_datetime(date2,format="%d/%m/%Y").date()

days = np.busday_count( date1 , date2)
print(days)

incase you want to provide holidays

holidays = pd.to_datetime("04/07/2019",format="%d/%m/%Y").date()
days = np.busday_count( start, end,holidays=[holidays] )
print(days)

edited Jun 20 '20 at 09:12

Community

1
1

answered Jul 25 '19 at 04:58

tawab_shakeel

3,701
10
26

Thanks...it can exclude weekends but in case i have list of holidays as well like holidays=["04/07/2019"] ......now difference should be 4 days ....can i incorporate it within a function ??? – Paras Ghai Jul 25 '19 at 05:07
ye can do that if you read documentation of np.busday_count there is a parameter of holidays where you can provide datetime list – tawab_shakeel Jul 25 '19 at 05:12
you have to try that parameter – tawab_shakeel Jul 25 '19 at 05:13
@ParasGhai I have updated the answer with holidays mask – tawab_shakeel Jul 25 '19 at 05:15

Calculate difference between two dates excluding weekends in python?

1 Answers1

incase you want to provide holidays

Linked