| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date "yyyymm"
I have a worksheet were the dates are displayed as 200901 (yyyymm --- no
slash) in column A. I need to add a formula to cells in colum C that will only substract any given number of months from this date, such as 200901 minus 13 months will equal 200811. Now, on the same boat, I would like to show the new date displayed as 11/01/2008. Thank you |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert numbers to date: "586" to read "May 1986" | Excel Worksheet Functions | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| Excel VBA to convert "dd.MM.yy" text to "dd/MM/yyyy" format date? | Excel Programming | |||
| Converting yyyymm and yyyymmdd to "mmm dd, yyyy" | Excel Discussion (Misc queries) | |||
| Why does the date change from "January 07" to a numercial value of "39038 " | Excel Programming | |||
Threaded Mode
