New to Excel - Need formula

mjaam · May 8th, 2002, 12:11 AM

Hi!
I am attempting to create a spreadsheet for cycle times on projects. Can someone help me figure out the formula for determining the number of days between a beginning date and an ending date, exluding weekends?

anno · May 8th, 2002, 12:16 AM

=NETWORKDAYS(start_date,end_date,holidays)
you'll need to have the analysis toolpak installed for this to work. if it's not go to tools menu>add-ins and select analysis toolpak
: )

[ This Message was edited by: anno on 2002-05-07 23:53 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 8th, 2002, 12:11 AM	#1
mjaam New Member Join Date: May 2002 Location: Milpitas, CA Posts: 1	Hi! I am attempting to create a spreadsheet for cycle times on projects. Can someone help me figure out the formula for determining the number of days between a beginning date and an ending date, exluding weekends?

May 8th, 2002, 12:16 AM	#2
anno Board Regular Join Date: Feb 2002 Posts: 202	=NETWORKDAYS(start_date,end_date,holidays) you'll need to have the analysis toolpak installed for this to work. if it's not go to tools menu>add-ins and select analysis toolpak : ) [ This Message was edited by: anno on 2002-05-07 23:53 ]