calendar working day calculation

[Afarag]

I want to calculate the working days for a limited duration. EX: I want start calculating from 1-Jan "15 Working Days without Vacations" that will end at 22-Jan. i want to put in the green cell 1-Jan cell, my duration that i want to calculate "15" - this Number isn't fixed - , then when click by mouse in any day, the last day for this duration light by green color. In all of months. The form of attached calendar is not must, I want a function or macro that help me to get this calculation

 

[Hui]

Afarag

Not really sure what outcome you want but
I would setup a list of the Holidays, not weekends in J6:J16
Then I would use a formula like
=WORKDAY.INTL($D$7,$E$4,7,$J$6:$J$16)
Which will return 22 Jan
D7 is the 1 Jan
E4 is the Number of work days
7 means Fri and Sat will be weekends
Holidays like Jan 24, Feb 13 etc will be listed in J6:J16

 

[Afarag]

MR Hui,
your follow up is highly appreciated
what i mean that i want a macro which help me to calculate a duration for working days without vacations from a specific date. Say EX: i want to calculate 7 working day from "15-mar" what the day will end this duration, by the way that mentioned in the attached sheet

 

[SirJB7]

Crossposted at:
http://chandoo.org/forum/threads/calendar-calculation.13514/

 

[Hui]

Afarag
The formula I gave you above does exactly that

=WORKDAY.INTL($D$7,7 ,7,$J$6:$J$16)
Which will return 22 Jan
D7 is the 15 Mar
7 (The first 7) is the Number of work days
7 (the second 7) means Fri and Sat will be weekends
J6:J16 List the public Holidays like Jan 24, Feb 13 etc in J6:J16
The formula will return the 7th workday after 15 Mar allowing for Weekends and holidays

ps: There is no need for Multiple Posts here. In fact they reduce the chance of you getting a solution

 

[Afarag]

Chapeau HUI

you are awesome a lot of thanks for follow up