Hello all, this forum has been really helpful so far, but i have a new
problem;

I have a worksheet that claculates lots of different things for a
single day, i have a second sheet which im using to compare some of the
things the first is calculating, but i dont want to have to manually
copy information from each cell to the right cell on the other sheet.

what im looking for is some kind of function (i assume it will have to
be logic based) which will tell me what the results of a cell would be
when the date is increased by one day

eg;

=E12 IF (date value+1),E12,""

where E12 would be the information i want to show, i cant seem to make
IF statements function in this way so any help would be much
appreciated, i basically need a formula which will incrimentally
increase the date value.

hope someone can help
thanks in advance

Owen


--
owen080808
------------------------------------------------------------------------
owen080808's Profile: http://www.excelforum.com/member.php...o&userid=32984
View this thread: http://www.excelforum.com/showthread...hreadid=533155