| Home |
| Search |
| Today's Posts |
|
#2
|
|||
|
|||
Lynne
This should do the trick for you. 'Borrowed' from a post a month or so back Remember they are text so no date calculations can be done without more string manipulation =CHOOSE(MATCH(A1,{"Jan";"Feb";"Mar";"Apr";"May";"J un";"Jul";"Aug";"Sep";"Oct";"Nov";"Dec"},0),"Apr", "May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","J an","Feb","Mar") HTH Rob |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a formula | Excel Worksheet Functions | |||
| need help creating formula based on cell value | Excel Discussion (Misc queries) | |||
| Creating a specific formula | New Users to Excel | |||
| Help in creating a formula | Excel Discussion (Misc queries) | |||
| Creating Formula using check boxes | Excel Discussion (Misc queries) | |||
Threaded Mode
