Hoping someone can suggest to me a formula for finding the percentage of the year completed between two dates.
My start of the year date is 1 April 2010, my date for year to date is 13 September 2010 – is there a function/formula in Excel that can calculate the percentage of the year completed up till 13 September 2010 ?? (assuming that the full year is till 01 April 2011)
I’ve tried searching Excel for a function & found PERCENTRANK a possibility but couldn’t make it work. I guess a formula will have to be created?
How will I format the date so the formula will work? 01/04/2010 or 01 April 2010 for example or will any date format work?
As for your stupid/error of judgement comment Atlantic Man, I have never needed to use Excel in any job I've had, I'm just familiarising myself with it for personal use. We all have to start somewhere. What a clown you are.
This thread is now locked and can not be replied to.