modified following business day convention
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 |
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 |
All times are GMT +1. The time now is 09:48 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com