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

2012-09-14 Thread Vabz
t; * * > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > * * > > *From:* excel-...@googlegroups.com [mailto: > excel-...@googlegroups.com ] *On Behalf Of *santosh subudhi > *Sent:* 14 September 2012 1:20 > *To:* excel-macros >

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
September 2012 1:20 To: excel-macros Subject: $$Excel-Macros$$ Calculate next working day Hi Group, I want to calculate the next working day where Monday to Saturday are the working days and it should also consider the holidays. For example, 1-Sept (Saturday) is the 1st working day and

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
can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: santosh subudhi To: excel-macros Sent: Fri, September 14, 2012 3:49:48 AM Subject: $$Excel-Macros$$ Calculate next

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://

$$Excel-Macros$$ Calculate next working day

2012-09-14 Thread santosh subudhi
Hi Group, I want to calculate the next working day where Monday to Saturday are the working days and it should also consider the holidays. For example, 1-Sept (Saturday) is the 1st working day and 3-Sept(Monday) is a holiday,so next working day is 4-Sept (tuesday) I cannot use working day functi