Personal timeout formula.

  • Good evening,


    On the 2nd row starting from B2 I have date (01.02.2018, 02.02.2018 .... 28.02.2018)
    I need a formula that writes the number 8 in every cell in row 3, starting with C3, and leaving empty the cells that on the 2nd are Saturday and Sunday plus the holidays that are in the DD column (say DD2: DD16) .
    The formula will be written in C3 and drawn to the right by the end of the month.


    Thank you.

  • Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.


    Remember to desensitize the data.

  • Thank you Matt for reply,


    Thanks for the formula. It needs to be slightly modified to take account of the duration (ie the date of A3 - start date and A5 - the final date.