Thread: First day and Last day of the month to display automatically
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mrbalaje mrbalaje is offline
external usenet poster
  
Posts: 24
Default First day and Last day of the month to display automatically
If I input the date 11-Apr-2007 in Cell B1. Then the Cell A1 should
automatically display the first day of the month(1-Apr-2007) and the Cell C1
should automatically display the last day of the month(30-Apr-2007).

If i input 12-May-2007 in B1, then A1 needs to be 1-May-2007 and C1 needs to
be 31-May-2007.

Any way to get this?
Reply With QuoteReply With Quote