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


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=561089