Thread: Date format
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ExcelHelpNeeded ExcelHelpNeeded is offline
external usenet poster
  
Posts: 6
Default 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

Reply With QuoteReply With Quote