| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date is backwards 20090123
How can I fix this? I had used a formula years back but can't remmeber how it
goes. Thanks =DATE(right(A1,2),mid(a1,5,2),left(A1,4)) but it does not work. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Forward & Backwards Quarters from an Entered Date | Excel Worksheet Functions | |||
| Excel is Backwards! | Setting up and Configuration of Excel | |||
| How do I calculate dates backwards from a project end date | Excel Worksheet Functions | |||
| vlookup backwards | Excel Worksheet Functions | |||
| Match Backwards | Excel Worksheet Functions | |||
Threaded Mode
