Reverse NETWORKDAYS function? gahagan[ at ]gmail.com 30.09.2006 16:26:09 Hi: I know the NETWORKDAYS function will output the NET number of WORKDAYS between a given start and finish date, skipping a given list of holidays--but does anyone know if there's a way to input a start date, a number of days, and a list of holidays, and get the finish date--? For example, say I wish a task to start on 10/2, and I know it will take me 10 workdays. How would I find the finish date if, for example, Friday the 6th is a holiday or day off? TIA, AG

Re: Reverse NETWORKDAYS function? Dave Peterson <petersod[ at ]verizonXSPAM.net> 30.09.2006 16:37:43 =workday() ??? gahagan[ at ]gmail.com wrote: [Quoted Text] > > Hi: > > I know the NETWORKDAYS function will output the NET number of WORKDAYS > between a given start and finish date, skipping a given list of > holidays--but does anyone know if there's a way to input a start date, > a number of days, and a list of holidays, and get the finish date--? > > For example, say I wish a task to start on 10/2, and I know it will > take me 10 workdays. How would I find the finish date if, for example, > Friday the 6th is a holiday or day off? > > TIA, > AG -- Dave Peterson

Re: Reverse NETWORKDAYS function? gahagan[ at ]gmail.com 30.09.2006 19:11:12 Never mind -- I ended up writing a custom function. Works like a charm! Dave Peterson wrote: [Quoted Text] > =workday() > ??? > > gahagan[ at ]gmail.com wrote: > > > > Hi: > > > > I know the NETWORKDAYS function will output the NET number of WORKDAYS > > between a given start and finish date, skipping a given list of > > holidays--but does anyone know if there's a way to input a start date, > > a number of days, and a list of holidays, and get the finish date--? > > > > For example, say I wish a task to start on 10/2, and I know it will > > take me 10 workdays. How would I find the finish date if, for example, > > Friday the 6th is a holiday or day off? > > > > TIA, > > AG > > -- > > Dave Peterson

Re: Reverse NETWORKDAYS function? "Tom Ogilvy" <twogilvy[ at ]msn.com> 30.09.2006 20:34:09 Why reinvent the wheel? Same place that has NetWorkdays has Workday which does exactly what you describe. -- Regards, Tom Ogilvy <gahagan[ at ]gmail.com> wrote in message news:1159643472.440968.184720[ at ]e3g2000cwe.googlegroups.com... [Quoted Text] > Never mind -- I ended up writing a custom function. Works like a charm! > > Dave Peterson wrote: >> =workday() >> ??? >> >> gahagan[ at ]gmail.com wrote: >> > >> > Hi: >> > >> > I know the NETWORKDAYS function will output the NET number of WORKDAYS >> > between a given start and finish date, skipping a given list of >> > holidays--but does anyone know if there's a way to input a start date, >> > a number of days, and a list of holidays, and get the finish date--? >> > >> > For example, say I wish a task to start on 10/2, and I know it will >> > take me 10 workdays. How would I find the finish date if, for example, >> > Friday the 6th is a holiday or day off? >> > >> > TIA, >> > AG >> >> -- >> >> Dave Peterson >