Something like this maybe?

=DATE(YEAR(A2), MONTH(A2)+1+(MONTH(WORKDAY(A2,10))<MONTH(A2)),0)

--
Rick (MVP - Excel)


"Jeff H" wrote in message
...
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.

Hope that makes better sense.

"Luke M" wrote:

Assuming you meant, if a date is within 10 days from end of month,
something
like this:

=IF(MONTH(WORKDAY(A2,10))=MONTH(A2),"Still have time","You're within 10
days")
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Jeff H" wrote:

OK, I am drawing a complete blank on this one. I'm having a total brain
glitch. Is this a sign that maybe I need to step away for a minute?
(Maybe.)

I need to determine if a particular date is greater than 10 business
days
from the last business day of the month.