Formula to exclude holidays


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.
 
Ad

Advertisements

Joined
Nov 26, 2010
Messages
5
Reaction score
0
Friend,


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

EvanDavis

Silly Fool
Joined
Jun 20, 2010
Messages
5,010
Reaction score
634
Saky said:
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 :D
 
Ad

Advertisements

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top