{"id":2015,"date":"2021-10-27T09:29:51","date_gmt":"2021-10-27T09:29:51","guid":{"rendered":"https:\/\/lgildv5i97.onrocket.site\/answers\/?post_type=question&#038;p=2015"},"modified":"2021-10-27T09:30:27","modified_gmt":"2021-10-27T09:30:27","slug":"multiple-dates-in-a-single-cell-of-excel","status":"publish","type":"question","link":"https:\/\/computing.net\/answers\/office\/multiple-dates-in-a-single-cell-of-excel\/12816.html","title":{"rendered":"Multiple Dates In a Single Cell Of Excel"},"content":{"rendered":"<p>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<br \/>\nI am using ALT + Enter along with comma to enter the multiple dates in one cell.<\/p>\n<p>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.<\/p>\n<p>Suppose i want to know the time and days between first start and first end (i.e 12-nov and 14-Nov)<\/p>\n<p>What is the process for the same? Is there any direct method for this<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"inline_featured_image":false,"iawp_total_views":10},"question-category":[53],"question_tags":[],"class_list":["post-2015","question","type-question","status-publish","hentry","question-category-office"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question\/2015","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question"}],"about":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/types\/question"}],"author":[{"embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/comments?post=2015"}],"wp:attachment":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/media?parent=2015"}],"wp:term":[{"taxonomy":"question-category","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question-category?post=2015"},{"taxonomy":"question_tags","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question_tags?post=2015"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}