LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Index/Contents Sheet philiphales Excel Discussion (Misc queries) 2 September 9th 05 08:58 AM
I need a daily sales sheet to pull from monthly figures sheet Draegen Excel Worksheet Functions 0 April 24th 05 05:58 AM
Sheet Protection -- Content vs. FORMATTING jayceejay New Users to Excel 1 March 29th 05 09:11 PM
difficulty with conditional formatting Deb Excel Discussion (Misc queries) 0 March 23rd 05 06:13 PM
Naming & renaming a sheet tab Cgbilliar Excel Worksheet Functions 1 November 7th 04 05:57 PM


All times are GMT +1. The time now is 10:01 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"