Home/ Questions/Q 2015
Next
Answered
computing
  • 7
Asked: 2021-10-27T09:29:51+00:00 In:

Multiple Dates In a Single Cell Of Excel

  • 7

I have a activity to record and there could be three to four dates for start of that activity(Suppose A1) and end of that activity (Suppose B1) {like the activity start on 12-nov-2010, 18-Nov-2010, 25-Nov-2010 and this same activity finishes on 14-Nov, 21-Nov, 26-Nov) So Cell A1 will have all three date i.e 12,18, 25 and cell b1 will have 14, 21 and 26 Nov
I am using ALT + Enter along with comma to enter the multiple dates in one cell.

I want to do some operation and date analysis on these two cell but i understand that the contents of these two cell is not in date format and as per my understanding it is in text format.

Suppose i want to know the time and days between first start and first end (i.e 12-nov and 14-Nov)

What is the process for the same? Is there any direct method for this

Share

    1 Answer

    1. Best Answer
      I supoose you could write a formula to extract a “date string” from your text, e.g. using some combination of MID, LEFT, RIGHT, FIND and then use that string inside the DATEVALUE function.

      My gut feeling is that it will be cumbersome and troublesome.

      Why can’t you split the dates into individual cells and use formatting to make them look like one cell?

      Using a fill color of White and light gray borders will make three cells look like a single cell with 3 lines but each individual entry will be an actual date.

      Posting Tip: Before posting Data or VBA Code, read this How-To.

      • 0