Hi
In a recent forum question Billy29 asked for help calculating the number of weeks between two dates and amongst the responses there were 3 answers which appeared to solve the question.
http://www.excelforum.com/excel-form...-of-weeks.html
When I tried the posted answers I found one solution gives an accurate week count and the other 2 gave the same incorrect week count, they consistently give a result that is one week to many.
I am a little confused, I doubt the authors of the two seemingly erroneous answer managed to make significantly different formulas that both result in an identical error... does anyone have a suggestion as to why this could be?
I have loaded a sheet with all three answers.
Regards.
Bookmarks