Month & Year Text to Date Format - Help Please
Hi,
I need some help as i'm stuck... I have a cell which has the number 4 in it (meaning April). I also have another cell which has the number 2010 in it (as text as it is concatenated from having the 20 manually added to the mid of another number giving the 10 part). So basically cell A1 has the number 4 in it, Cell B1 has the number 2010 in it. How do I get these 2 together to give me a date format of 01/04/2010 in an Excel recognisable date format to use in a vlookup with another preformatted date cell? Any help greatly appreciated! |
Month & Year Text to Date Format - Help Please
Hi
=DATE(B1,A1,1) Regards, Per "Louise" skrev i meddelelsen ... Hi, I need some help as i'm stuck... I have a cell which has the number 4 in it (meaning April). I also have another cell which has the number 2010 in it (as text as it is concatenated from having the 20 manually added to the mid of another number giving the 10 part). So basically cell A1 has the number 4 in it, Cell B1 has the number 2010 in it. How do I get these 2 together to give me a date format of 01/04/2010 in an Excel recognisable date format to use in a vlookup with another preformatted date cell? Any help greatly appreciated! |
Month & Year Text to Date Format - Help Please
Hi,
With 4 in A1 & yiur text 2010 in b1 try this =TEXT(1&"/"&A1&"/"&B1,"dd/mm/yyyy") -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Louise" wrote: Hi, I need some help as i'm stuck... I have a cell which has the number 4 in it (meaning April). I also have another cell which has the number 2010 in it (as text as it is concatenated from having the 20 manually added to the mid of another number giving the 10 part). So basically cell A1 has the number 4 in it, Cell B1 has the number 2010 in it. How do I get these 2 together to give me a date format of 01/04/2010 in an Excel recognisable date format to use in a vlookup with another preformatted date cell? Any help greatly appreciated! |
Month & Year Text to Date Format - Help Please
Mike & Per - thanks for your input.
Mike, your answer looked great but couldn't bve formatted to a date which I needed as it was a text formula but worked perfectly for presentation. Per, your answer fitted the bill perfectly, worked a treat! I am very grateful to you both for your help! :) Louise "Louise" wrote: Hi, I need some help as i'm stuck... I have a cell which has the number 4 in it (meaning April). I also have another cell which has the number 2010 in it (as text as it is concatenated from having the 20 manually added to the mid of another number giving the 10 part). So basically cell A1 has the number 4 in it, Cell B1 has the number 2010 in it. How do I get these 2 together to give me a date format of 01/04/2010 in an Excel recognisable date format to use in a vlookup with another preformatted date cell? Any help greatly appreciated! |
All times are GMT +1. The time now is 06:10 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com