Hi,
I'm having trouble sorting a date issue on an Excel 2000 file, where
there are blanks.

I've got the data copied to a separate sheet and have Date 1 in the first
column and Date 2 beside that.
It was easy to take date 1 from 2 and get the number of days in-between (for
use in a countif function & graphing). My problem is that the main data page
has a lot of empty cells in it, and on copying this across it comes out at
01/01/1900 on my data/graph page

How do I get Excel to ignore the blank cells?

Thanks,


Malcolm