Thread: Populate days of the month in a column by checking on date
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Joe Joe is offline
external usenet poster
  
Posts: 476
Default Populate days of the month in a column by checking on date
Is it possible to populate a column with the days of any given month by
checking on a cell reference to a date?

For example if A1 contained 2/28/2009 is there a way for the system
to populate B1 through B28 with the dates of the month? Then if you changed
A1 to 3/31/2009 have it populate B1 through B31 with the dates for March?


Reply With QuoteReply With Quote