Thread: To show month end date from any date entered
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
tigermoth tigermoth is offline
external usenet poster
  
Posts: 13
Default To show month end date from any date entered
If Cell A1 is 29/07/2008, how to I formulate cell D1 to show 31/07/2008,
15/08/2008 to 31/08/2008 etc ( ie rounding up the date in column A to show
month end date in column D.

Thanks
Reply With QuoteReply With Quote