Blog

How to do Date Formulas in Different Scenarios in Excel

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)




Click here for downloading the workbook


 

Video Link: Watch Video

Phone : +91 8606648045
Email : info@excelskillcorner.com
Excel Skill Corner
Kerala, India.