Thread: Determine begin month date from month end date.
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
mikeburg[_60_] mikeburg[_60_] is offline
external usenet poster
  
Posts: 1
Default Determine begin month date from month end date.

I got an error using the above line. However, after I modified it t
the line below it worked great:

'MonthBeginDate = DateSerial(Year(Range("F5")), Month(Range("F5")), 1)

Thanks very, very much. mikebur

--
mikebur
-----------------------------------------------------------------------
mikeburg's Profile: http://www.excelforum.com/member.php...fo&userid=2458
View this thread: http://www.excelforum.com/showthread.php?threadid=50112

Reply With QuoteReply With Quote