I am looking to input a formula that I can have a date range of 7 days continue on the next date range of 7 days when I copy the formula down to the next cell. for example: I start the beginning of the date range as 01/03-01/09 which is 7 days (Monday through Sunday). I want the cell below it to go the next 7 days in date range. example: 01/10-01/16. I have been unable to find a formula that works because of the format I have my date range as. each date just needs to add 7 days to it in next new cell, unsure how to make that happen.

  • 01/10-01/16
  • 01/17-01/23
  • 01/24-01/30


enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.