Mirroring Excel totals, previous week percentage differences and calculating grand totals

Question

My boss has asked me to automate an excel file he originally composed manually. This includes percentage differences, negative and positive indicators (color correlated) , totals, grand totals, and percent differences from when this first file was composed.

I've managed to accurately generate the aging buckets totals and grand totals.  But when generating the percentages and their associated indicators + the layout of the whole thing.....Well....It's become very difficult to emulate these lingering portions.  Here is a small example of what I'm trying to obtain....

Examples2.xlsx

Maskell_Rascal · Answer

@ccano both of those should be possible to calculate using some DateTime functions, but it all depends on how your data is structured prior to you outputting it to the reporting tools.

ccano · Answer

Thanks Phil @Maskell_Rascal , this is very cool!  I was wondering in this case, how can I obtain the % differences from each sectors "improvement" week over week? And also , how can I get the percentage difference from Day 1, when the file was originated? I've tried several calculations but all end up failing.

atcodedog05 · Answer

Thats neat @Maskell_Rascal  🙂👍