I don't think a defined tables will work in my situation. ive done a lot of research on how to create this workbook as efficiently as possible. to help with coming up with the solution to my problem I have included a copy of the worksheet that I am writing now.

the first page of this workbook is intentionally left blank so that I can input the data on a daily basis, hence the page name daily. The sheet labeled weekly is the sheet that my sumifs question comes into play. the 2 highlighted rows are the 2 left to do date corrections on. if you look at the column labeled total miles it has the correct date configuration done all the way down. I'm looking to see if there is a faster way to write this up so that I don't have to go threw each cell and do date corrections to get the outcome that I am looking for. I'm sorry if I gave any confusion to this question and hopefully now that I have included and shown what I am looking for and explained it a lot better there is an answer that will work for this scenario.

Attached Files

2018 Lease Pay.xlsx (20.7 KB, 13 views)