Hi,

I need a calculation wherein the user just enters a begin date and then my
formula adds a few months and days to that date and suggests a date, but it
does not consider holidays and weekends in the calc.

For example If I suggest April15, the formula should be able to find out
that April 15 is sunday and also April 16 is Holiday, so it should suggest
April 17.

Does anyone have any idea for this.

Will be glad to receive your response.

try the holidays parameter of networkdays

http://support.microsoft.com/kb/259200

--


Gary


"Abhishek" <Abhishek @discussions.microsoft.com> wrote in message
news:40A84FF1-0CF5-4A29-B195-(E-Mail Removed)...
> Hi,
>
> I need a calculation wherein the user just enters a begin date and then my
> formula adds a few months and days to that date and suggests a date, but it
> does not consider holidays and weekends in the calc.
>
> For example If I suggest April15, the formula should be able to find out
> that April 15 is sunday and also April 16 is Holiday, so it should suggest
> April 17.
>
> Does anyone have any idea for this.
>
> Will be glad to receive your response.

I am using Excel 2003. Does networkdays work in 2003 also?

"Gary Keramidas" wrote:

> try the holidays parameter of networkdays
>
> http://support.microsoft.com/kb/259200
>
> --
>
>
> Gary
>
>
> "Abhishek" <Abhishek @discussions.microsoft.com> wrote in message
> news:40A84FF1-0CF5-4A29-B195-(E-Mail Removed)...
> > Hi,
> >
> > I need a calculation wherein the user just enters a begin date and then my
> > formula adds a few months and days to that date and suggests a date, but it
> > does not consider holidays and weekends in the calc.
> >
> > For example If I suggest April15, the formula should be able to find out
> > that April 15 is sunday and also April 16 is Holiday, so it should suggest
> > April 17.
> >
> > Does anyone have any idea for this.
> >
> > Will be glad to receive your response.
>
>
>

yes, just install the analysis toolpak add-in.

--


Gary


"Abhishek" <(E-Mail Removed)> wrote in message
news:BFC4E50D-51BB-4652-9825-(E-Mail Removed)...
>I am using Excel 2003. Does networkdays work in 2003 also?
>
> "Gary Keramidas" wrote:
>
>> try the holidays parameter of networkdays
>>
>> http://support.microsoft.com/kb/259200
>>
>> --
>>
>>
>> Gary
>>
>>
>> "Abhishek" <Abhishek @discussions.microsoft.com> wrote in message
>> news:40A84FF1-0CF5-4A29-B195-(E-Mail Removed)...
>> > Hi,
>> >
>> > I need a calculation wherein the user just enters a begin date and then my
>> > formula adds a few months and days to that date and suggests a date, but it
>> > does not consider holidays and weekends in the calc.
>> >
>> > For example If I suggest April15, the formula should be able to find out
>> > that April 15 is sunday and also April 16 is Holiday, so it should suggest
>> > April 17.
>> >
>> > Does anyone have any idea for this.
>> >
>> > Will be glad to receive your response.
>>
>>
>>

Yes, that worked, thanks a lot Gary...

"Gary Keramidas" wrote:

> yes, just install the analysis toolpak add-in.
>
> --
>
>
> Gary
>
>
> "Abhishek" <(E-Mail Removed)> wrote in message
> news:BFC4E50D-51BB-4652-9825-(E-Mail Removed)...
> >I am using Excel 2003. Does networkdays work in 2003 also?
> >
> > "Gary Keramidas" wrote:
> >
> >> try the holidays parameter of networkdays
> >>
> >> http://support.microsoft.com/kb/259200
> >>
> >> --
> >>
> >>
> >> Gary
> >>
> >>
> >> "Abhishek" <Abhishek @discussions.microsoft.com> wrote in message
> >> news:40A84FF1-0CF5-4A29-B195-(E-Mail Removed)...
> >> > Hi,
> >> >
> >> > I need a calculation wherein the user just enters a begin date and then my
> >> > formula adds a few months and days to that date and suggests a date, but it
> >> > does not consider holidays and weekends in the calc.
> >> >
> >> > For example If I suggest April15, the formula should be able to find out
> >> > that April 15 is sunday and also April 16 is Holiday, so it should suggest
> >> > April 17.
> >> >
> >> > Does anyone have any idea for this.
> >> >
> >> > Will be glad to receive your response.
> >>
> >>
> >>
>
>
>