Count in Date Range + more Excel tips
January 06, 2015
In this week's Excel news, you'll see how to count activities in a date range, and much more., and more, in this week's Excel news. Visit my Excel website for more tips, tutorials and videos, and check the index for past issues of this newsletter.
Note: For some products mentioned below, I earn a commission on sales. That helps support the free tutorials on my site.
How many guests stayed at a hotel during a specific date range? It's a little tricky to figure out, but you can compare the guests' arrival and departure dates to the reporting period's start and end dates. You can do more complicated calculations too, to get the number of nights the hotel rooms were booked in a date range.
Click here to see the details, and download the sample file: Count Activities in Date Range
Excel stores dates as serial numbers, and over the holidays, I noticed that we hit day 42000, on December 27, 2014. We don't see those round numbers too often, so can you guess when day 43000 will arrive?
You can figure it out in Excel, or check the answer in my blog post, Day 42000 in Excel
Here are a few of the Excel articles that I read recently, that you might find useful:
The ADDRESS function returns a cell address as text, based on a row number and column number. For example, you could find the address of the cell with the largest value in a range of cells. Watch this video to see how to use the ADDRESS function, and combine it with other Excel functions.
I hope you enjoyed some time with friends and family at the end of the year, and celebrated the beginning of 2015. We had our family here on Christmas Eve and Christmas morning, and had lots of fun.
Perhaps I took a few too many pictures though, as you can see in the photo below. My grandson and granddaughter seem reluctant to pose for one more!
That's it for this week! If you have any comments or questions, send me an email.
Last updated: February 20, 2020 6:53 PM