Hi all,

I'm looking to get some help on an excel formula. I have the date range 10/20/2007 (A1) through 1/13/2008 (B1). What I want to determine is how many days are there in each month for this date range.

I can figure out the first month easily:
=DAYS360(A1,EOMONTH(A1,0),FALSE)+1

But, after that, it gets a little more tricky... Any help from you would be great. Thanks!

Goldy