View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kjharris123
 
Posts: n/a
Default formatting end of month on a monthly sheet


I'm working on a simple Excel doc that is used to take
readings on power usage three times a day for every day of the month.
The month and year is entered at the top of the sheet, and the day
cells in the sheet will format fine. The sheet has enough room for
all 31 days of the month. My question is, is there any way to write
the formula that if the month only has 29 days the last two date boxes
(30and 31) blank?

Thanks,
Kjharris


--
kjharris123
------------------------------------------------------------------------
kjharris123's Profile: http://www.excelforum.com/member.php...o&userid=29715
View this thread: http://www.excelforum.com/showthread...hreadid=494306