| 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
|
|
|
|
|