Formula to exclude holidays

S

Saky

Joined
Nov 26, 2010
Messages
5
Reaction score
0
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.
 
Friend,


The sample threads which you gave me doesnt help me...Can you kindly give me the formula for my below case.
 
Saky said:
Friend,


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


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 :D
 
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!!!
 
Back
Top