Thread: Incrementing dates in the format MMM-YY
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default Incrementing dates in the format MMM-YY
put a date in A1 and in A2 put:
=DATE(YEAR(A1),MONTH(A1)+1,1) and copy down
--
Gary''s Student - gsnu200750
Reply With QuoteReply With Quote