Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Generating date from day, month year
Hello all,
Is there any way I can generate a date in one cell, from 3 other separate cells - one each for day, month, year? i.e. if you enter (for example) '01' in A1, 'September' in A2 and '2009' in A3, then in B1 it shows '01/09/2009'. Alternatively, is there a way I can generate the month from the date - so if you enter (for example) '01/09/2009' in A1, it shows 'September' in B1? Many thanks in advance for your help, N |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Generating date from day, month year
"Ned Harrison" wrote:
Is there any way I can generate a date in one cell, from 3 other separate cells - one each for day, month, year? i.e. if you enter (for example) '01' in A1, 'September' in A2 and '2009' in A3, then in B1 it shows '01/09/2009'. I assume the apostrophes (single quotes) are not really in the cell. And I assume you want the date value (number) 1/9/2009, not text. Try: =--(A1&A2&A3) formatted as Date or the custom format mm/dd/yyyy, depending on Regional and Language settings. On the off-chance that you want the text "01/09/2009", try: =text(A1&A2&A3, "mm/dd/yyyy") Alternatively, is there a way I can generate the month from the date - so if you enter (for example) '01/09/2009' in A1, it shows 'September' in B1? =text(A1, "mmmm") |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Generating date from day, month year
Hi Ned,
For the date, try =DATEVALUE(A1&"/"&A2&"/"&A3) with A1 = day, A2 = September, A3 = year To get the month of a given date, try to format the cell: number, custom: 'mmmm' (without the quotes). Wkr, JP "Ned Harrison" wrote in message ... Hello all, Is there any way I can generate a date in one cell, from 3 other separate cells - one each for day, month, year? i.e. if you enter (for example) '01' in A1, 'September' in A2 and '2009' in A3, then in B1 it shows '01/09/2009'. Alternatively, is there a way I can generate the month from the date - so if you enter (for example) '01/09/2009' in A1, it shows 'September' in B1? Many thanks in advance for your help, N |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Generating date from day, month year
Col A Col B
1 =DATEVALUE(A1&"-"&A2&"-"&A3) September =TEXT(B1,"mmmm") 2009 If this post helps click Yes --------------- Jacob Skaria "Ned Harrison" wrote: Hello all, Is there any way I can generate a date in one cell, from 3 other separate cells - one each for day, month, year? i.e. if you enter (for example) '01' in A1, 'September' in A2 and '2009' in A3, then in B1 it shows '01/09/2009'. Alternatively, is there a way I can generate the month from the date - so if you enter (for example) '01/09/2009' in A1, it shows 'September' in B1? Many thanks in advance for your help, N |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Generating date from day, month year
Thanks all - that's brilliant.
Cheers, Ned |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
count month when date is in day/month/year format | Excel Worksheet Functions | |||
=DATE(YEAR(P4),MONTH(P4)+1,1) | Excel Worksheet Functions | |||
Tell me which "season" (Month/Day through Month/Day) a date(Month/Day/Year) falls in (any year)??? | Excel Discussion (Misc queries) | |||
Date -Month/day/year | Excel Discussion (Misc queries) | |||
Sort month/date/year data using month and date only | Excel Discussion (Misc queries) |