Hi Don, thanks for the fudge. Unless I did something wrong, I get different results.
Take f.i. startDate:August 3, 2007 endDate: September 30, 2007. Tom's calc gives August 1 and September 1. Out of that I can calc the days as part of the 'beginning' and 'end' month. Your CF gives only August 1 and no September.... Second test: startDate: August 3, 2006 endDate September 30, 2007. Tom's calc and your CF are ok until the last month. Your CF seems not to take the last month into account, even if there is only 1 day in that month. I can start to change numbers/digits/syntax in the CF, but I rather want to know first if the outcome that I have is correct according to you.
