Re: $$Excel-Macros$$ Calculate next working day

2012-09-14 Thread Vabz
Hey.. Rilli great logic.. Cherz.. Vabz On Friday, September 14, 2012 8:20:48 PM UTC+5:30, Rajan_Verma wrote: > *I1:I3 is holiday list* > > * * > > * > =IF(WEEKDAY(A1,2)=5,IF(COUNTIF(I:I,A1+1)=0,A1+1,WORKDAY(A1,1,$I$1:$I$3)),WORKDAY(A1,1,$I$1:$I$3)) > * > > * * > > * * > > *Regards* > > *Raja

Re: $$Excel-Macros$$ Calculate next working day

2012-09-14 Thread Paul Schreiner
o all the people you can, As long as ever you can.” - John Wesley - From: santosh subudhi To: excel-macros Sent: Fri, September 14, 2012 12:00:11 PM Subject: RE: $$Excel-Macros$$ Calculate next working day Hi Paul, I am

RE: $$Excel-Macros$$ Calculate next working day

2012-09-14 Thread Rajan_Verma
I1:I3 is holiday list =IF(WEEKDAY(A1,2)=5,IF(COUNTIF(I:I,A1+1)=0,A1+1,WORKDAY(A1,1,$I$1:$I$3)),WOR KDAY(A1,1,$I$1:$I$3)) Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of santosh subudhi Sent: 14 Se

Re: $$Excel-Macros$$ Calculate next working day

2012-09-14 Thread NOORAIN ANSARI
. > > I am unable to incorporate the formula in excel. It would be so nice of > you if incorporate the same in a excel sheet. > > -- > Regards > Santosh > santoshkumar.subu...@gmail.com > > -- > Date: Fri, 14 Sep 2012 15:27:47 +0530 >

RE: $$Excel-Macros$$ Calculate next working day

2012-09-14 Thread santosh subudhi
Hi Paul, I am using the excel 2007 version. -- Regards Santosh santoshkumar.subu...@gmail.com -- Date: Fri, 14 Sep 2012 04:21:30 -0700 From: schreiner_p...@att.net Subject: Re: $$Excel-Macros$$ Calculate next working day To: excel-macros@googlegroups.com What

Re: $$Excel-Macros$$ Calculate next working day

2012-09-14 Thread Paul Schreiner
What version of Excel are you using? In Excel 2010, there is a variation of the WorkDay function called Workday.INTL WORKDAY.INTL(start_date, days, [weekend], [holidays]) Returns the serial number of the date before or after a specified number of workdays with custom weekend parameters. Weekend

Re: $$Excel-Macros$$ Calculate next working day

2012-09-14 Thread NOORAIN ANSARI
Dear Santosh, Please try it.. *=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(I52&":"&J52)),2)<6))* Hope it will meet your expectation. -- With Regards, Noorain Ansari http:// noorainansari.com http://