Programatically changing date ranges per column
I created a capacity overview sheet that sums the hourly allocation of co-workers between two dates, i.e. between today() and today(7), so one week from now. I would now like to extend that functionality to between today(8) and today(14), today(15) and today(21), and so on.
Is there a smart way to do this programmatically?
Thanks in advance,
Help Article Resources
Check out the Formula Handbook template!