| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date "yyyymm"
If 200901 was in cell A1, and 13 in B1, this formula:
=DATE(LEFT(A1,4)-INT(B1/12),RIGHT(A1,2)-B1+12*INT(B1/12),1) should do what you want. I make it 01/12/07 (or 12/01/07 for America...) not november 08 though. Sam "Memphis" wrote: 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
