Sorry but I don't get it...
If 12 columns correspond to months, then where are the days;
surely not the rows since there are 1000! Are you saying that in each
column you can have 1000 date entries; for example:

*Say column 2, row 5 has: 02/03/06 and column 4, row 5 has 04/16/06.
Are you asking for the days spanned formatted as the number of months
and remainder (i.e., days).
*Do you have an actual example of your data available???


--
protonLeah
------------------------------------------------------------------------
protonLeah's Profile: http://www.excelforum.com/member.php...o&userid=32097
View this thread: http://www.excelforum.com/showthread...hreadid=535551