Need to count the weekdays or weekends between two dates?Date Range Calculator will make the job an easy one.And speaking of dates, today is the deadline to get a 20% discount on Mynda Treacy’s upcoming Excel Dashboard Course.It’s a great course, and will quickly get you up and running with dashboards.While I could see my dad dating someone around 37 (although he’s married so he won’t be!) I just couldn’t imagine him having anything in common with someone who was 100.Again, you can see the original article that this discussed this idea in detail over at Insatiable Hee.In this example, the start date is in cell D13, and the end date is in E13. Note that this result also needs to be formatted as a number. Then click Number Now we need to find the number of remaining days.
Need an easy way to calculate the days or hours between to dates?
This formula subtracts the first day of the ending month (5/1/2016) from the original end date in cell E17 (5/6/2016).
Here's how it does this: First the DATE function creates the date, 5/1/2016. Then, we subtract that from the original end date in cell E17, which is 5/6/2016. You can put all three calculations in one cell like this example. It’s a longer formula to type, but at least it’s all in one.
With that in mind, I decided to try my hand at an equation by adding a hard cap to to both the upper and lower limit.
Things still aren’t perfect but the ranges seem more reasonable.
That divides the number of days by 7, since there are 7 days in a week.