Link to home
Start Free TrialLog in
Avatar of Rrave26
Rrave26

asked on

Excel 2013 Date Range Calculation

I have an excel report that reports data by week and the date range is in one column (B), i.e., 12/7 - 12/13, 12/14 - 12/20, 12/21 - 12/27, 12/28 - 1/3, 1/4 - 1//10, 1/11 - 1/17, 1/18 - 1/24 and 1/25 -  1/31... I do this for all 52 weeks of the year and then start over again with the new year.  This reports data from Mon Morning starting at 00:00 and reports through Sunday night at 23:59.  

I need help with creating a formula that calculates the weeks range for all 52 weeks.  Any ideas?
ASKER CERTIFIED SOLUTION
Avatar of Rgonzo1971
Rgonzo1971

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Rrave26
Rrave26

ASKER

Thanks.  It works perfectly.  I just wasn't thinking about a helper column.