Advanced Date Formula?

Utradeshow

Well-known Member
Joined
Apr 26, 2004
Messages
747
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
MNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAP
1801/23/05TO01/23/05Days
195
20
2101/25/05TO01/20/05
Origin Info
 

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

martinee

Well-known Member
Joined
Nov 4, 2003
Messages
960
Have you considered using the Workday() function?

HTH

*Edit*Too slow....
 

Utradeshow

Well-known Member
Joined
Apr 26, 2004
Messages
747
Ok, well how about a formula that would take the date if during the weekend, It would make it the Monday after the weekend?
 

Forum statistics

Threads
1,148,269
Messages
5,745,781
Members
423,972
Latest member
franklins

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top