View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default modified following business day convention

On Thu, 17 May 2007 04:17:01 -0700, Don wrote:

It's a businness day function where if using EDATE plus Sat/Sun-Mon takes
you into the next month, then it goes to the preceeding business day



Perhaps:

=IF(MONTH(WORKDAY(EDATE(A1,NumMnths)-1,1))=MONTH(EDATE(A1,NumMnths)),
WORKDAY(EDATE(A1,NumMnths)-1,1),WORKDAY(EDATE(A1,NumMnths),-1))

will work for you?
--ron