Hello All:
I have a spreadsheet that I need to have the dates for the month. On this
application I needed the First of the month in one cell and the last day of
the month listed in another. I inserted a calendar that allows me to put the
selected date into the active cell. (Formatted ddd mmmm dd yyyy) The I use
the formula =DATE(YEAR(C6),MONTH(C6)+1,DAY(C6)-1) to enter the last day of
the month into the appropriate cell. (Formatted mmmm dd yy) The problem I am
having is that this formula works on most of the dates in a month but gives
me a #NUM! Error when it is asked to give me the last day of the month. I
other words if I select the first day of a month it gives me #NUM! If I
select the second day of the month it returns the first day of the next
month, if I select the 15th it returns the 14th of the next month. So it
seems to give me the next month less on one day as I want in most cases
except the first day of the month. The other thing that is perplexing is
that it did work at one time, so I am thinking I have done something to
change it but for the life of me I cannot figure out what. The dates that
return #NUM! a Jan 30 & 31, Feb1, March 1, April 1, May 1, June 1, July 1,
August 1, (Aug 11 thru 31 returns ##############), Sept 1, Oct 1, Nov 1, and
all of the month of Dec 2005. Is this a must be a corrupt file!!!!! I have
deleted the object and reinserted it and there was no change. Help!!!
I am using xl2000