Auto-setting the Date for a Dashboard
If you are like me you frequently have to update various excel based dashboards. In the pursuit of even more automation, I thought it would be fun to make Excel figure out the current date and automatically set the date of my dashboard to the end of the previous week.
All you need is three Excel [...]
