Thread: A formula or macro that determine the correct month
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Leith Ross[_545_] Leith Ross[_545_] is offline
external usenet poster
  
Posts: 1
Default A formula or macro that determine the correct month

Hello leitek.com,

Try this method...

Days = EndingDate - StartingDate
MonthEnd = StartingDate + (Days/2)

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=512537

Reply With QuoteReply With Quote