Formula to return the date only with working days

Asked

Viewed 1,188 times

-1

Is there any formula I can use for the cell to return the date corresponding to the term?

If I enter the date 03/01/2020 in the cell, I want another cell next to return the date with the calculation of 5 working days.

It would look like this: 03/01/2020

The cell on the side would return 10/01/2020 automatically considering only working days.

Since I already typed the cells as date, a simple sum would solve the case. Assuming that the value of A1 is 03/01/2020

=A1+5

It returns me 08/01/2020 when it should actually be 10/01/2020. The problem is that it doesn’t just consider working days.

excel spreadsheets

  • Put the code you have already tried to do, and you have already looked at this https://answall.com/questions/23537/f%C3%b3rmula-para-calculable-intervals-num%C3%a9ricos-no-excel? Rq=1 ?

  • I didn’t understand how the formula SE could help in this case. Even if conditions apply, it would not return the date.

  • Then post the part of the code you’re in trouble with

  • Okay, Kalibban, I’ve inserted my failed attempt.

  • In fact it will return you 08/01/2020 because you are making a sum.

  • Exactly, I was wondering if there’s any way to set up the count just with working days, but there shouldn’t be, I guess.

  • The DIATRABALHO function does just that. https://support.office.com/pt-br/article/diatrabalho-fun%C3%A7%C3%A3o-diatrabalho-f764a5b7-05fc-4494-9486-60d494efbf33

  • @anonimo the function DIATRABALHO needs to be passed the 2 dates as parameter,and from what I understand it will give the entry at any date and inform 5 days,so that from there occurs the return of the date accounting 5 working days.

  • 1

    @KALIBBAN: I believe you have confused the DIATRABAT function with the DIATRABAT function.

  • @anonimo really i puzzled,but still both need to have 2 dates as parameter,and what he is trying to do and pass a date and a number of days.

Show 5 more comments

1 answer

1


  • If: A1 = 03/01/2020, A2 = 5 and in C1 I have the holiday 20/01/2020, the formula: =DIATRABALHO(A1;A2;C1) will result: 10/01/2010. Se: A1 = 16/01/2020, A2 = 5 and in C1 I have the holiday 20/01/2020, the formula: =DIATRABALHO(A1;A2;C1) will result: 24/01/2010.&#Considering weekends as Saturdays and Sundays there is no need to use the function DIATRABALHO.INTL.

  • @anonymity in this way you oblige the person to inform a holiday date on C1, this is also possible with the function DIATRABALHO.INTL,where it only needs to inform the initial date and having the option to calculate holidays or weekends,so I think valid use it.

Browser other questions tagged excel spreadsheets

You are not signed in. Login or sign up in order to post.