Thread: date list in 1 month increments
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
bcamp1973
 
Posts: n/a
Default date list in 1 month increments

I want to enter a date in field A1 and have every field after that
display the date in one month increments. So if A1 is 4/30/2006, then
A2 will be 5/30/2006 etc. I've tried using [=EDATE(A1,1)] as suggested
in Excel Help files, but it's returning #NAME? Not sure what I'm doing
wrong?


--
bcamp1973
------------------------------------------------------------------------
bcamp1973's Profile: http://www.excelforum.com/member.php...o&userid=32268
View this thread: http://www.excelforum.com/showthread...hreadid=520200

Reply With QuoteReply With Quote