02/05/2018

  1. W

    Pivot Table Help with a Calculated Field...

    Thought I'd repost this as the formatting did not come through correctly in the original post...apologies. One thing I did try was to use MAX and MIN on the date fields to determine number of shifts being looked at and therefore get an accurate value: =DAYS360(MIN(C3:C17),MAX(C3:C17)) It...
  2. A

    Sheet formula to calculate maximum gap between dates

    Hi all. I have the following problem: I have a table and for each record there are multiple date fields. Here is a brief example (these dates use the British format of Day/Month/Year): <tbody> Date1 Date2 Date3 Date4 Date5 Date6 06/09/2017 03/11/2017 06/10/2017 28/09/2017...
  3. M

    Turn a string date into Date and Time values

    I am looking to extract the date into DD-MM-YYYY format and append the start date <style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>May 2, 20181:00 PM - 1:45 PM PT to become 02/05/2018 13:00:00 I have split the string with the following...

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