Formula to exclude holidays

[Saky]

Hi Friends,


Can any one kindly provide me formula to calculate the date excluding saturday and sundays.

For example: Start date = 29/Nov/2010 in Col A
And if i give in col B as 7(i.e., Adding 7 days from the start date)
In col c i need the result as 8/Dec/2010. Excluding the saturday and sundays.

Kindly help.

 

[EvanDavis]

Hi Saky

I think you will have better luck if you look HERE

 

[Saky]

Friend,


The sample threads which you gave me doesnt help me...Can you kindly give me the formula for my below case.

 

[EvanDavis]

Friend,


The sample threads which you gave me doesnt help me...Can you kindly give me the formula for my below case.

On this occasiom I did not give you a sample. I gave you a link to a forum that could help you. Sound really like you are on a colelge course and you want somebody to do your home work for you.
From the sample I gave you in another post, if you had the slightest idea you would have figured out your answer

 

[Saky]

Hi,


Now i found the formula....Thanks for guiding me..

I dont want anyone to do my home work...I just need some wherever i am struck..

Thanks for your great help!!!