On Thu, 16 Jul 2009 11:04:18 -0700, Jeff H
wrote:

Thanks, Luke. Actually, what I looking at is...
If Date 10 business days from the last business day of the month
Then Close Date = End of Month
Else Close Date = End of (Month+1)

I'm pretty sure that I have the End of Month calculations down right.
End of Month = Date(Year(Date), Month(Date)+1,0)
End of (Month+1) = Date(Year(Date),Month(Date)+2,0)

For example, the last business day of this month (July) is 31st. So, Close
Date for July 16 would be July 31. However, Close Date for July 20 would be
August 31.

One formula for that would be:

=IF(NETWORKDAYS(A1,DATE(YEAR(A1),MONTH(A1)+1,0))1 0,
DATE(YEAR(A1),MONTH(A1)+1,0),DATE(YEAR(A1),MONTH(A 1)+2,0))

A little shorter version:

=DATE(YEAR(A1),MONTH(A1)+2-(NETWORKDAYS(
A1,DATE(YEAR(A1),MONTH(A1)+1,0))10),0)

--ron