Hi Harmeet
Thanks for the formula. It works perfectly when the start day is not
included.

Aindril De:
Thanks Aindril for raising the concern as said above. Anyways I was working
on the solution.

Dilip Pandey:
Thanks for the nice formula. But I am not getting the result when I vary the
duration (ie no of days). The end day includes the saturdays and sundays
between the start date and end date which is the first thing I wanted to
eliminate.
*
Roger Govier
Roger, Thanks for your effort. This really works perfectly including the
start date.*

Thanks group for helping to sort out our difficulties in excel.

Best Regards
Praveen Khunte

On Fri, May 1, 2009 at 1:54 PM, Dilip Pandey <dilipan...@gmail.com> wrote:

> Hi Praveen,
>
> You can use following function:-
>
>
> =IF(TEXT(B3+F3-1,"DDD")="Sat",B3+F3-1+2,IF(TEXT(B3+F3-1,"DDD")="Sun",B3+F3-1+1,B3+F3-1))
> Note: Excel file is also attached for your reference.
>
> Thanks & Best Regards,
> --
> DILIP KUMAR PANDEY
>   MBA-HR,B COM(Hons.),BCA
> Mobile: +91 9810929744
> dilipan...@gmail.com
> dilipan...@yahoo.com
> New Delhi - 110062
>
> On Thu, Apr 30, 2009 at 7:33 PM, Praveen Khunte 
> <praveen.khu...@gmail.com>wrote:
>
>> Hi All Excel Lovers
>>
>> I have attached the excel sheet with the problem description.
>> Hope to get solution.
>>
>> Praveen Khunte
>>
>>
>>
>
>
>
> >
>

--~--~---------~--~----~------------~-------~--~----~
-------------------------------------------------------------------------------------
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-------------------------------------------------------------------------------------
-~----------~----~----~----~------~----~------~--~---

Reply via email to