Calculate a date after number of days without considering weekend holidays

[rameshppc]

Hi every one,

I am proud to be getting help from Mrexcel team on my every intoxicated situation on handling excel sheets.

Thanks team and now i need a help from you.

I am doing pan card service for people. i am entering the booking date in excel, i need a formula to show the date, after 10 from booking without considering weekend saturday & sunday.

Also its possible, to make the formula will consider the dates i written in particular cell as a holiday

 

[asjmoron]

Re: Calcute a date after number of days without considering weekend holidays

You can use =NETWORKDAYS

for example, =NETWORKDAYS(A1,A2) WIll count all days between a1 and a2 excluding weekends.

You can add holidays by putting them in a rabge for example B:B

So your formula would be =NETWORKDAYS(A1,A2,B:B)

 

[steve the fish]

Re: Calcute a date after number of days without considering weekend holidays

Workday will do that:

=WORKDAY(A1,10,holidays)

where A1 contains the booking date and 'holidays' is a named range containing the holiday dates.

 

[rameshppc]

Re: Calcute a date after number of days without considering weekend holidays

Hi asjmoron,

Thanks for your quick response...
I have only one input as starting date (A1)
I need the A2 value to be generate by the formula, by using the constant value as number of days (its 10)
Hope you will understand what i am expecting...
can you pls give the formula accordingly?

 

[rameshppc]

Re: Calcute a date after number of days without considering weekend holidays

Hi steve,

You given formula is closer to my required answer...
I need the (saturday & sunday) holidays date constantly in formula and also i need provision to add some government holidays.

 

[rameshppc]

Re: Calcute a date after number of days without considering weekend holidays

Hi.. I am eager to see your answer...

 

[steve the fish]

The required answer has been provided. What doesn't it do that you want?

 

[rameshppc]

Hi steve,
I need the (saturday & sunday) holidays date constantly in formula and also i need provision to add some government holidays.

 

[steve the fish]

Yeah that's what you have in the formula. It ignores sat and sun and holidays.

 

[rameshppc]

Hi steve... really sorry..
I checked your formula on yesterday. the result came as "#Name?"

Now again i tried, its working awsome.. thanks...