Contextures

Contextures News 20150106

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.

Count in Date Range

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

Count in Date Range

Excel Day 42000

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

Excel Day 42000

More Excel Tips

Here are a few of the Excel articles that I read recently, that you might find useful:

Video: ADDRESS Function

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.

Too Many Pictures

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!

weekly hoto

That's it for this week! If you have any comments or questions, send me an email.

Debra Dalgleish
dsd@ contextures.com

Debra Dalgleish

P.S. You can choose the full Contextures news package (news and occasional special announcements), or basic news package (news only). Click either link to change your option.

 

Last updated: February 20, 2020 6:53 PM