jh3016,
FYI & FFR (for future reference)
You may have been "Stuck" with data that you inherited from another person.
But when you CREATE your own data/stucture, that has ANYTHING to do with dates (ie days, months, years) use REAL DATES!
Real Excel Dates are simply NMBERS. Like
Today is 38080, however, when you enter a date, you usually enter something like 4/3/2004. Excel is SMART enough to RECOGNIZE that you have entered a DATE, CONVERTS the sring of characters that you entered to a NUMBER and FOMATS the NUMBER to display as 4/3/2004.
THEN...
if you were to CHANGE the format in Format/Cells - Number Tab, Category: Custom, Type:
mmmm and [OK]...
your DATE would be DISPLAYED as...
April
The date VALUE is STILL 38080!
Entering date-related data as a REAL DATE makes REAL SENSE and aids in the manipulation of the data.
Skip,
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884