Add weekend days to the total amount

[lastminuteproject]

Hi all,

I making some planning for my company and they make all the calculations as a working days. I need something like this:

Cell A=Starting date
Cell B= End date
Cell C= Number of working days

I want that cell B get calculated starting from A and adding C and the corresponding weekend days.

I made something that work, but only for working days less than a week:

Cell A: Start date
Cell B: =IF(C1="Y",A1+D1+1,A1+D1-1) -->IAdd 2 days if we go through a weekend
Cell C: =IF(WEEKDAY(A1)+D1>5,"Y","N") -->Tell if we go through a weekend
Cell D: working days

Anyone can help me?

Thank you in advance

 

[Jon von der Heyden]

Hi and welcome to the board.

I believe you are after WORKDAY:

=WORKDAY(A1,B1)

Where A1 is the start date and B1 is the number of days to add. WORKDAY also takes a 3rd argument where you can pass a range of holiday dates to exclude too. E;g,

=WORKDAY(A1,B1,J1:J10)

 

[JackDanIce]

If you require value in cell B2, try:

=TEXT(WORKDAY(A2,C2,2),"DD/MM/YY")

 

[lastminuteproject]

Oooh man!! That was easy. I was smashing my brain with never ending formulas and relations

That really solve my problem.

Thank you a lot for the fast answer