View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default 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