| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
DATE() Month in Letter NOT Number
In Date(year,month,day) function, all need to be number, what if I have month
in letter, how can I use date function? I've tried a different way by using if, nested function only allow 7 or 8 of them, so I can't nest the function all the way to December. If(A1=January,01,if(A1=February,02......and so on) Anyone have any suggestions on how to do this? Thanks, GU |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert date to number representing Month | Excel Discussion (Misc queries) | |||
| Adding a number to a letter of the alphabet to get a letter | Excel Worksheet Functions | |||
| change headers from letter to number/number to letter | Excel Worksheet Functions | |||
| column header changed from letter to number, how return to letter | Excel Discussion (Misc queries) | |||
| Returning the Week Number of a Specific Date on a Month | Excel Worksheet Functions | |||
Threaded Mode
