02/05/2018

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

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

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