Thread: How do I set up 12-month rolling month cells in excel?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave O
 
Posts: n/a
Default How do I set up 12-month rolling month cells in excel?
With TODAY() in cell B2, try this formula:
=EOMONTH(B2,1)
.... then copy and paste into subsequent cells in the continuum.

You may require some experimentation to get your desired results.

Reply With QuoteReply With Quote