Calculate working dates.

amna77

Active Member
Joined
May 9, 2002
Messages
251
Hi, in cell A1, I have date like Oct 10. now in cell B1, I want to put a formula. Right now I have formula
=IF(ISERR(A1/A1)=TRUE,"",A1+10-IF(C5="Assy",10,))

this formula forward 10 days form cell A date. Like for example, If Cell A have March 10, then it gives me March 20, but if in cell c I have "Assy" then it does not add 10 days, it leaves the date like it is.

But now I want to add only 10 working days to that date. I want to ignore weekends.
Anybody know how I am going to modify my formula according to that?

Thanks
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
59,414
Office Version
  1. 365
Platform
  1. Windows
Use the Workday function. Type "workday" in help and it will tell you how to use it. You will need at add the Analysis Toolpak Add-In, if you don't already have it, to use this function.
 

amna77

Active Member
Joined
May 9, 2002
Messages
251
In a workday function help, it does not tell me, that how to add days to one date. they have start date and end date examples.
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
59,414
Office Version
  1. 365
Platform
  1. Windows
Sure it does, that is exactly what it does. Read the description again.

For example, if you wanted to add 10 business days to today, it would be:

=workday(today(),10)
This message was edited by jmiskey on 2002-10-31 09:24
 

Forum statistics

Threads
1,143,923
Messages
5,721,557
Members
422,370
Latest member
A Nonomus

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