modified following business day convention

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
Click to expand...


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
 
Back
Top