| 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 |
| 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) | |||
![Ned Harrison[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
