select case date

  1. B

    IF Statement Or Select Case Help Please

    Good Morning Guys, I hope you are all well. I am just in the process of setting up a new part time employee on a Holiday Spreadsheet I have made which uses NETWORKDAYS to determine the amount of holiday the user is after. So when the User selects for example 12.04.17-13.04.17 that would be 2...
  2. M

    Select Case - Based on Date:

    Afternoon all, Just require a wee bit of help with the following code. It sits in the "This Workbook" code window to run each time the wbook is opened. What I want it to do, is based on the date in Sheets("Control").Range("L3") select a particular cell in another sheet called "Risk Sum". I'm...

Some videos you may like

This Week's Hot Topics