Advanced Date Formula?

Utradeshow

Well-known Member
Joined
Apr 26, 2004
Messages
749
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 the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

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
749
Ok, well how about a formula that would take the date if during the weekend, It would make it the Monday after the weekend?
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,117
Messages
5,768,213
Members
425,459
Latest member
Danniey

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