| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date format
I have a date format - 5/31/06 10:30 AM
1. How would I get just the month and year? 2. What formula can I write that tells me that this date was 16 months ago from August of 2007. Thanks, RB |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date format
On Wed, 29 Aug 2007 16:11:19 -0700, ExcelHelpNeeded
wrote: I have a date format - 5/31/06 10:30 AM 1. How would I get just the month and year? Either just format it as "Format/Cells/Number/Custom Type "mmm-yyyy" or use the formula =text(cell_ref,"mmm-yyyy") or some similar format. 2. What formula can I write that tells me that this date was 16 months ago from August of 2007. =datedif(early_date,later_date,"m") where early_date and later_date are cell references. --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert European Date format to American Format | Excel Discussion (Misc queries) | |||
| Convert date from text format to date format | Excel Discussion (Misc queries) | |||
| Convert date + time text format to date format | Excel Worksheet Functions | |||
| Can I change a date with no format (20051111) to date format? | New Users to Excel | |||
| Excel 2000 date format cannot be set to Australian date format | Excel Discussion (Misc queries) | |||
Linear Mode
