craig@help Wrote:
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/06?

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

Craig

Back again, sorry for confusing, just worked it out which project this
is for (=if(isnumber(a1),a1,"")format as a date), yes this does work,
however still litte problem, let me see if i can work it out 1st.

Cheers for info.

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