Dav Wrote:
you are not being very clear

what is $A$S for example

We have now idea how your spreadsheet is laidout, give us more idea or
include an example, what is g10 what is s1? Is a jod on one line or
over several

2) if(isnumber(a1),a1,"") format as a date

Regards

Dav

Sorry M8, my mistake with typing, $A$S should be $A$5.

G10 is where i want the result to be place at.

=if(isnumber(a1),a1,"")format as a date

this above to helps to work out between like between 01/04/05 and
31/03/05?

Do u require attachment? I'm happy to send one example.

Craig


--
craig@help
------------------------------------------------------------------------
craig@help's Profile: http://www.excelforum.com/member.php...o&userid=36201
View this thread: http://www.excelforum.com/showthread...hreadid=561089