| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Date Display?
Hello
Let's Suppose i gave some date 01-01-2007 in cell A1 and 01-05-2010 in cell b1 if i Subtract Cell B1 from A1 so the Answer will be 1100 Days BUT i want these days as date like 6 days 1 months and 3 Years OR 01/06/03 Is it Possible ? Please Help |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel date format, NOT JUST DISPLAY !! | Excel Worksheet Functions | |||
| display extension for date in excel | Excel Discussion (Misc queries) | |||
| Excel 2003: date display issue | Excel Discussion (Misc queries) | |||
| Display Last Saved Date Excel | Excel Discussion (Misc queries) | |||
| How do I display the last saved date in an EXCEL spreadsheet? | Excel Discussion (Misc queries) | |||
Threaded Mode
