LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
cummingse
 
Posts: n/a
Default Date Formula Help


I am tring to create a formuls that will allow me to do the following:
In cell A1 have a start date, let's say 02/01/05 and in cell B1
02/02/05 and so on all the way to the end of the month.
But when I get to the end of the month the cell that would contain the
date of 02/29/05 would be blank if it is not a leap year and if it is a
leap year then it would show the date of 02/29/05.
Thanks a million for any help.


--
cummingse
------------------------------------------------------------------------
cummingse's Profile: http://www.excelforum.com/member.php...o&userid=25611
View this thread: http://www.excelforum.com/showthread...hreadid=394246

 
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
Formula checking multiple worksheets sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 03:28 AM
addition to my date formula...required Juco Excel Worksheet Functions 5 January 30th 05 11:48 AM
Excel formula with date constraints Warrior Pope Excel Discussion (Misc queries) 3 January 28th 05 03:08 PM
Formula with date constraints Warrior Pope Excel Worksheet Functions 1 January 28th 05 02:11 PM
Need help troubleshooting an array formula XLXP on Win2K KR Excel Worksheet Functions 1 December 13th 04 07:41 PM


All times are GMT +1. The time now is 03:39 PM.

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"