Thx Aindril/Abhishek,
I will try your solutions and let you know if I need any further help.
Regards,
Roopesh Kapur
On Apr 7, 3:07 pm, Aindril De wrote:
> This is another alternative
> solution:http://www.mrexcel.com/forum/showthread.php?t=86072
>
>
>
> On Wed, Apr 7, 2010 at 3:29 PM, Aindril
This is another alternative solution:
http://www.mrexcel.com/forum/showthread.php?t=86072
On Wed, Apr 7, 2010 at 3:29 PM, Aindril De wrote:
> OOps.. Sorry missed the link...
> Here is the link:
> http://spreadsheets.about.com/od/excelfunctions/qt/080321networkda.htm
>
> Hope this helps...
>
> Re
OOps.. Sorry missed the link...
Here is the link:
http://spreadsheets.about.com/od/excelfunctions/qt/080321networkda.htm
Hope this helps...
Regards,
aindril
On Wed, Apr 7, 2010 at 2:31 PM, L.K. Modi wrote:
> Dear Aindril
>
>
> As i m seeing this mail there is no link at all in your mail. Is
Roopesh,
Try this:
=NETWORKDAYS(A2,B2)+SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A2&":"&B2)))=7))
Where - A2 is start date and B2 is end date.
Cheers!
AJ
On Wed, Apr 7, 2010 at 12:29 PM, RK wrote:
> Hi Champs,
>
> I am looking for a formula or an add in that works like networkdays,
> the only dif
Dear Aindril
As i m seeing this mail there is no link at all in your mail. Is there any
way to calculate networking days
Regards
LKModi
On Wed, Apr 7, 2010 at 2:20 PM, Aindril De wrote:
> Hi Roopesh,
>
> The process given in the link below will be a good start.
> Regards,
> Aindril
> On W
Hi Roopesh,
The process given in the link below will be a good start.
Regards,
Aindril
On Wed, Apr 7, 2010 at 12:29 PM, RK wrote:
> Hi Champs,
>
> I am looking for a formula or an add in that works like networkdays,
> the only difference being that I want saturday to be included as a
> working d
Hi Champs,
I am looking for a formula or an add in that works like networkdays,
the only difference being that I want saturday to be included as a
working day, rest everything to remain same as Networkdays.
Regards,
Roopesh Kapur
--
--
