I need to create a formula where I add a set number of Networkdays to a
start date. Example:

Start Date = 1/2/07
Number of Networkdays = 21
End Date = Is calculated

If Start = 1/2/07 and 21 Networkdays are added, what is the retured end
date????

I can only find example of Networkdays where I would be providing the
Start and End Dates, and it will calculate the Networkdays. I can't
find example where End Date is calculated based on the number of
networkdays from start date.

Can anyone help with a valid formula for this?

Thanks!!

Look for =workday() in Excel's help.
(Also part of the analysis toolpak)

(E-Mail Removed) wrote:
>
> I need to create a formula where I add a set number of Networkdays to a
> start date. Example:
>
> Start Date = 1/2/07
> Number of Networkdays = 21
> End Date = Is calculated
>
> If Start = 1/2/07 and 21 Networkdays are added, what is the retured end
> date????
>
> I can only find example of Networkdays where I would be providing the
> Start and End Dates, and it will calculate the Networkdays. I can't
> find example where End Date is calculated based on the number of
> networkdays from start date.
>
> Can anyone help with a valid formula for this?
>
> Thanks!!

--

Dave Peterson

Dave,

It sounds as though you may need to calculate workdays in each month. The
excel function is =eomonth(start_date,no of months to calculate days on).
For example eomonth(1/2/7,0) returns 1/31/7. So in your formula you would
have =networkdays(1/2/7,eomonth(1/2/7,0)) would return 22 days.
Substituting a 1-12 in the last parameter for eomonth would count the days
in all months through the number of months past january.

This isn't the final answer you are looking for but you could experiment
with it.
the eomonth function is in the analysis pak.

"Dave Peterson" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Look for =workday() in Excel's help.
> (Also part of the analysis toolpak)
>
> (E-Mail Removed) wrote:
>>
>> I need to create a formula where I add a set number of Networkdays to a
>> start date. Example:
>>
>> Start Date = 1/2/07
>> Number of Networkdays = 21
>> End Date = Is calculated
>>
>> If Start = 1/2/07 and 21 Networkdays are added, what is the retured end
>> date????
>>
>> I can only find example of Networkdays where I would be providing the
>> Start and End Dates, and it will calculate the Networkdays. I can't
>> find example where End Date is calculated based on the number of
>> networkdays from start date.
>>
>> Can anyone help with a valid formula for this?
>>
>> Thanks!!
>
> --
>
> Dave Peterson

First, it wasn't me who asked the question.

Second, it sounds more like an =workday() question (well, to me anyway).

Jerry wrote:
>
> Dave,
>
> It sounds as though you may need to calculate workdays in each month. The
> excel function is =eomonth(start_date,no of months to calculate days on).
> For example eomonth(1/2/7,0) returns 1/31/7. So in your formula you would
> have =networkdays(1/2/7,eomonth(1/2/7,0)) would return 22 days.
> Substituting a 1-12 in the last parameter for eomonth would count the days
> in all months through the number of months past january.
>
> This isn't the final answer you are looking for but you could experiment
> with it.
> the eomonth function is in the analysis pak.
>
> "Dave Peterson" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > Look for =workday() in Excel's help.
> > (Also part of the analysis toolpak)
> >
> > (E-Mail Removed) wrote:
> >>
> >> I need to create a formula where I add a set number of Networkdays to a
> >> start date. Example:
> >>
> >> Start Date = 1/2/07
> >> Number of Networkdays = 21
> >> End Date = Is calculated
> >>
> >> If Start = 1/2/07 and 21 Networkdays are added, what is the retured end
> >> date????
> >>
> >> I can only find example of Networkdays where I would be providing the
> >> Start and End Dates, and it will calculate the Networkdays. I can't
> >> find example where End Date is calculated based on the number of
> >> networkdays from start date.
> >>
> >> Can anyone help with a valid formula for this?
> >>
> >> Thanks!!
> >
> > --
> >
> > Dave Peterson

--

Dave Peterson