mercredi 25 mars 2015

Excel convert date to text retaining date layout

I have rows containing every Monday and Sunday in an entire year, (with variations on when a month starts and ends) like so,



11/05/2015 18/05/2015 25/05/2015 01/06/2015 08/06/2015
17/05/2015 24/05/2015 31/05/2015 07/06/2015 14/06/2015


However these are in the date format, and I need them in a text format, but so they still read in the dd/mm/yyyy format, not like 42125.


Further up my document, each column header should read dd/mm/yyyy-dd/mm/yyyy using each of the dates shown in my first example, and I was hoping to achieve this using the formula =A30&"-"&A31 and so on. So the desired outcome should read,



11/05/2015-17/05/2015 18/05/2015-24/05/2015

11/05/2015 18/05/2015
17/05/2015 24/05/2015


However using the =cell&cell formula im left with



42135-42141 42142-42148

11/05/2015 18/05/2015
17/05/2015 24/05/2015


I have to create these headings for 2 years worth of dates, and trying to avoid typing every heading out manually, is there a way to achieve this?


Aucun commentaire:

Enregistrer un commentaire