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...

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top