Thread: Incrementing dates in the format MMM-YY
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
kmewing kmewing is offline
external usenet poster
  
Posts: 8
Default Incrementing dates in the format MMM-YY
Yes, that works great. Thanks!

"Gary''s Student" wrote:

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