No. days between dates excl. Sat & Sun ie work days only

Feb 19th, 2002, 12:30 PM

Is it possible to have a formula which calculates the no. of days between 2 dates, but excludes Sat & Sun?

e.g. 04/02/02 & 16/02/02 = 10 working days

Scott · Feb 19th, 2002, 12:41 PM

Quote:

On 2002-02-19 11:30, Anonymous wrote:
Is it possible to have a formula which calculates the no. of days between 2 dates, but excludes Sat & Sun?

e.g. 04/02/02 & 16/02/02 = 10 working days

You can use =NETWORKDAYS(A1,A2) Assuming that A1 contains the start date, and A2 contains the end date.

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

Feb 19th, 2002, 12:30 PM	#1
Guest Posts: n/a	Is it possible to have a formula which calculates the no. of days between 2 dates, but excludes Sat & Sun? e.g. 04/02/02 & 16/02/02 = 10 working days