Hi there
I'm attempting to set up a record of contracts via excel.
I'd like to implement a cell that serves as a reminder for whether or not action should be taken depending on the date and end of contract date (ie more than 12 months left = green, 12 to 9 months left = amber, 9 - 6 months...
Hi all
Recently I was messing around with the timestamp formula (see Chandoo's article here: http://chandoo.org/wp/2009/01/08/timestamps-excel-formula-help/), and figured I could use it to help maintain version control on my project documents at work.
The sheet documents the current version...
Hi all
I'm attempting to create an issue register that will check the last 30 days' activity (open and closed) much like Chandoo's example.
I have racked my brains and I cannot configure the formulas to track the last 30 days!
I've uploaded the file - any advice is much appreciated...
Hi there
I've set myself the goal of creating an awesome chandoo-esque SWOT chart in excel (Strength, Weakness, Opportunities, Threats) - anybody had any experience with this or know of any decent resources out there?