# Blog

#### How to do Date Formulas in Different Scenarios in Excel

Many of the Excel users are searching about to solve the issue of the calculations of the Dates, where we need to face different scenarios in the calculation of the Dates and here we are discussing five major scenarios.

Scenario-1

How to Calculate Days between two dates

Formula Syntax

=DAYS(end_date,start_date)

And in this case it will exclude the starting date and if you want to include the starting date please add one ie. =DAYS(end_date,start_date)+1

Scenario -2

How to Calculate Working Days (if the holidays on Saturday and Sunday)

Formula Syntax

=NETWORKDAYS(start_date,end_date.[Holidays])

Scenario -3

How to calculate working days if the only Sunday is holiday

Formula Syntax

=NETWORKDAYS.INTL(start_date,end_date,[weekend],[holidays])

Scenario -4

How to calculate working days in specific days (eg Wednesday,Thursday and Friday)

Formula Syntax:

=NETWORKDAYS.INTL(start_date,end_date,[â€œ1â€0r â€œ0â€])

Where â€œ1â€ indicates Non-Working Day

Where â€œ0â€ indicates Working Day

Order of the day will be (Monday,Tuesday,Wednesday,Thursday,Friday,Saturday, Sunday)

So in this Formula will be =NETWORKDAYS.INTL(start_date,end_date,â€1100011â€)

Scenario 5

How to calculate the specific day in the period (Tuesday)

Formula Syntax:

=NETWORKDAYS.INTL(start_date,end_date,â€1011111â€])

Where â€œ1â€ indicates Non-Working Day

Where â€œ0â€ indicates Working Day

Order of the day will be (Monday,Tuesday,Wednesday,Thursday,Friday,Saturday,Sunday)