That'll work. Thank you very much!

Rick Rothstein (MVP - VB) wrote:
Your layout is a little hard to follow (the spacing got crowded), but let me
ask you this... is the E19 currently in your formula (and what you want to
be E20 on September 1st) the date for the last day of the current month? If
so, you should be able to simply replace E19 in your formula with this...

DATE(YEAR(TODAY()),MONTH(TODAY())+1,0)

and it will automatically calculate the last day of the month for the
current month for you.

Rick

I've been trying to find an answer to a question I think I should know the
answer to with no luck. I hope someone can help me. I need to have a
[quoted text clipped - 69 lines]
35 $3,660 35 Nov-10 $4,705 ($325) -6.5% 25.3%
36 $3,405 36 Dec-10 $4,485 ($220) -4.7% 24.1%

--
Message posted via http://www.officekb.com