01/10/2018

  1. M

    Conditionally format rows of information

    Hiya, I'm hoping somebody can help. I want to use conditional formatting in the end column called all courses complete. I want the end column to be red and say no until all 6 courses have been completed. Once I put all 6 dates into each course column I want the end column to turn green and...
  2. K

    Start and End NETWORKDAYS by month

    Hi I need some help with formula/ function to return NETWORKDAYS per month based on Start Date and End date (including public, annual holidays). I've tried to use IF(AND and I always have too many arguments to get the correct result (exact number of WDs be per month based on start and end date...
  3. E

    Offset

    Hello I need help with the OFFSET formula please. I have a list of dates - for ease lets use the following - 01/10/2018 01/11/2018 03/12/2018 02/01/2019 I am attempting to have a list, whereby if I change the list to say 01/11/2018, another cell will change to the next date, if it >TODAY()...
  4. E

    How to identify the right starting point of a sum based on criteria?

    Hello, I have the two rows: 26/09/2018 27/09/2018 28/09/2018 29/09/2018 30/09/2018 01/10/2018 02/10/2018 03/10/2018 04/10/2018 05/10/2018 06/10/2018 07/10/2018 08/10/2018 4 5 2 0 0 0 6 9 7 0 0 2 4 (copy/paste them in excel as I have no idea how to paste as table) In a separate cell, I...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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