• About the site - Computer News Deals.com
  • Computer News Deals.com is a web portal with very unique concept of news blended with other important aspects of computer and internet technology.
Home : May 19 2016 Computer News : How Excel counts business days, holidays and more

How Excel counts business days, holidays and more

May 19, 2016

Kumar Malyala asked if there’s a way in Excel to count the number of business days between two dates. It’s easy to find the number of days between two dates in Excel. You just subtract the earlier date from the later one. If you put July 19 in A1, May 5 in A2, and enter =a1-a2 in A3, you’ll get 75—the number of days between May 5 and July 19. However, if you don’t want Saturdays and Sundays in your total, you’ll have to work a bit harder. And if you need to take holidays into consideration, it gets trickier still. But not too tricky. [Have a tech question? Ask PCWorld Contributing Editor Lincoln Spector. Send your query to answer@pcworld.com.]To read this article in full or to leave a comment, please click here

Link: http://www.pcworld.com/article/3056908/software/how-excel-counts-business-days-holidays-and-more.html#tk.rss_howto
Related News
Theresa Wise, CIO Veteran, Joins Impinj Board of Directors
topcreditcardprocessors.com Announces Credit Card Processing Specialists as the Second Top Credit Card Processing Service for May 2016
Homefront: The Revolution review: A mess of a game with grandiose ambitions
Google Assistant is like a conversational Google Now on steroids