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

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