Hi...i appreciate your concern! Im getting a number when i change the format
to general. so i assume they are true dates. could you tell me what should i
do in both the scenarios? thanks

"swatsp0p" wrote:


Question: Are cells A1 in both sheets truly dates? Remember that Excel
stores dates as a number (e.g. May 19, 2006 = 38856). To check, change
the format of each cell to General and see if you get a number similar
to my example. If not, then you don't have true dates in each cell
(maybe one is a text entry?).

HTH

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=543766