answersLogoWhite

0


Best Answer

For Excel:

  1. Format A1 and A2 in the date format you prefer.
  2. Put your first date in A1 and your second date in A2.
  3. In A3, put the following formula: =A2-A1
  4. Observe the number of days between the two dates displayed in A3.
User Avatar

Wiki User

14y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you calculate the number of days between two dates including weekends and bank holidays?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

How many hours a day can a 16 year old work in England?

School days:No more than 2 hours in one day.From 7am to the time your school starts.Then from the time school closes until 7pm.Working during school hours is illegal.Saturdays:Up to 5 hours between 7am and 7pmSundays:Up to 2 hours between 7am and 11amTerm Time (including weekends):Maximum of 12 hours a week, including weekends. 7am-7pm.School Holidays (including weekends):Maximum of 25 hours a week composed of -- 5 hours a day between 7am - 7pm on any day except Sunday- 2 hours between 7am-7pm on a Sunday.


What are the weekdays?

Weekdays are the days between and including Monday and Friday. The only days of the week that are not weekdays are the weekends, Saturday and Sunday.


What time schedule riyadh to jubail saptco bus?

The time schedule of Saptco bus from Jubali to Riyadh is between 8 am and 9 am. It usually travels all weekdays and some weekends and holidays.


What is the Timing of secondary divisional board office vashi?

The secondary divisional board office in Vashi is open from Monday to Friday between 10:00 AM to 5:00 PM. It is closed on weekends and public holidays.


Difference between during summer holidays and in summer holidays?

during summer holidays is a time within the summer holidays, and summer holidays are summer holidays altogether.


EDD phone interview on weekends?

Yes they do schedule interviews on the weekends, mine is next Saturday between 8 AM and 10 AM.


How long to deliver mail from WI to MO?

between 2-7 days, it depends on holidays and weekends


On avergage how expensive is a rental car?

Cost of rental cars vary depending on type of car, location of rental, and miles driven with vehical. Weekends and holidays will also increase the cost. You are looking at anywhere between $20 per day to over $500 for a week.


What is the difference between French and English school holidays?

The french get more and longer holidays


How many days is 7-10 business days?

Every day except Saturday, Sunday and holidays are business days. 7-10 business days is maximum 14 days (2 weeks) unless there are any holidays in those 2 weeks.


When is the next October with 5 weekends?

because of leap years, October has 5 weekends alternating between every 6 years and every 11 years. The next Octobers with 5 weekends will be 2021 and 2027.


What time does Disneyland close?

Every Day from 9:00am to 6:00pm** **Summer Closing Time: 7:30pm