Date format

E

ExcelHelpNeeded

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
 
R

Ron Rosenfeld

I have a date format - 5/31/06 10:30 AM

1. How would I get just the month and year?
Click to expand...

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.
Click to expand...

=datedif(early_date,later_date,"m")

where early_date and later_date are cell references.
--ron
 
Top