change embedded date automatically

is there a way to automatically increment the date by 1 for each successive row with this as the original formula:


=SUM(‘M:FY 2018 DepositsDeposit Detail[JUL 11, 2017.xl sm]Deposit Recon’!$E$6:$E$11)


I have 365 spreadsheets for each day of last 5 years. All are formatted the same. I need to consolidate info from specific cells into an annual spreaadsheet for each year

By: Garth M Malena

4 thoughts on “change embedded date automatically

  1. ig

    Great blog! Do you have any tips and hints for aspiring writers?
    I’m hoping to start my own site soon but I’m a little lost on everything.
    Would you advise starting with a free platform like WordPress
    or go for a paid option? There are so many choices out there that I’m totally confused ..
    Any tips? Appreciate it!

  2. Charley Blashak

    I’m not that much of a internet reader to be honest but your sites really nice, keep it up! I’ll go ahead and bookmark your site to come back down the road. Many thanks

Comments are closed.