Advanced Date Formula?

[Utradeshow]

Hi Guys, I have a sheet I'm trying to have add dates to create a delivery spread..

Here it goes.. the source cell being (M18) has 01/23/05

I need the delivery cell (M21) to display M18 + the number of days in cell (AN19) in this case being "5" EXCLUDING WEEKENDS so the result in cell (M21) should be 01/28/05

and finally in cell (AA21) would be (M21) + 2 Days Also Excluding weekends so the result in (AA21) would be 01/31/05

Thank you,

Total Show Program.xls
	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP
18	01/23/05											TO			01/23/05													Days
19																												5
20
21	01/25/05											TO			01/20/05
Origin Info

 

[Juan Pablo González]

Take a look at the NETWORKDAYS that is available when you install the Analysis Toolpak Addin.

 

[martinee]

Have you considered using the Workday() function?

HTH

*Edit*Too slow....

 

[Juan Pablo González]

Oops, yes, NETWORKDAYS is for counting... use WORKDAY()

 

[Utradeshow]

Ok, well how about a formula that would take the date if during the weekend, It would make it the Monday after the weekend?