Calculating 10 Business Days from the Last Business Day of the Mon
On Thu, 16 Jul 2009 10:35:01 -0700, 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.
If your particular date is in A1, and if the last business day of the month
also refers to the same month as the date in A1, then:
=IF(NETWORKDAYS(A1,DATE(YEAR(A1),MONTH(A1)+1,0))1 0,
"More","Less")&" ten (10) business days"
--ron
|