And Rick is my hero...

Rick Rothstein (MVP - VB) wrote:
For those following this thread, the OP sent me a copy of the workbook
offline. After looking at it, I suggested he try this formula...

=IF(D6<=B$1,E5-$H$4,INDEX(B$10:B$1000,DATEDIF(B$1-DAY(B$1)+1,D6-DAY(D6)+1,"m")))

in E6 and copy it down. He wrote back to me (offline) that the formula
worked, so I guess we can consider this question as having been answered.

Rick

Thank you. It's on its way.

[quoted text clipped - 10 lines]

Rick

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200807/1