Hi, Here is a solution that should meet your needs. BR, Lionel
Hi, Excel can perform this task perfectly. But, I'm not going to do everything for you ;-). So, it would be nice if you could already show what you...
Andrea, When you are not using a structured table, you must use a line-by-line formula. The easiest way is to start from the first line (which work...
Hi Andrea, Here is the function : WORKDAY.INTL function WORKDAY.INTL(start_date, days, [weekend], [holidays]) The WORKDAY.INTL function ...
Hi Laura, When you post a question, it is a good idea to specify whether you are using Excel or Calc or... The errors you mention seem to come from...
Then my proposal works (# post 5). See cells in green. BR, Lionel
Hi, Can you download your file again because I make a mistake when I try to take it? BR, Lionel
Hi, Here is a proposal but some information is missing to give an answer that works 100% of the time. What does c=10w mean? Will the cell cont...
Hi Ishwar, Can you attach the announced file? Thank you, BR, Lionel
Hi Louise, Here is a solution in column I (in blue). BR, Lionel
Hi Andy, Could you add in the file several cases with the expected solution? BR, Lionel
Hi Paul, Here is an adaptation of the file taking into account the public holidays (which are on D2:D9). I have added an M column with the new resu...
Hi Paul Here is the adaptation for the WE. I added a column E (in green) with the new formula. BR, Lionel
Paul, For the 360/60/24, there is no reason. It's just that at certain times the brain does certain things automatically. You are absolutely right ...
Hi Riste Chaushev, Here are the steps (and the file) for only USCHALL sheet. USCHALL sheet Do not use a structured table Name the cells A2...