date not correct in cell
 

Hi
I formatted cell A1 to date cell
till sofar the date 01-11-06 appears as requested in that cell

When I copy A1 to B1 (B1=A1) it gives also the correct date

When I put in B1 the formule
=IF(D1="";"";"The date is ";A1) it shows The date is 39022

(programmed in Excel2003 and copied to Excel2000)
What is wrong
Please help
Thanks in advance
Ron

date not correct in cell
 

=IF(D1="";"";"The date is ";text(A1;"mm/dd/yyyy"))

Did you really mean to use D1 and A1?

wrote:

Hi
I formatted cell A1 to date cell
till sofar the date 01-11-06 appears as requested in that cell

When I copy A1 to B1 (B1=A1) it gives also the correct date

When I put in B1 the formule
=IF(D1="";"";"The date is ";A1) it shows The date is 39022

(programmed in Excel2003 and copied to Excel2000)
What is wrong
Please help
Thanks in advance
Ron

--

Dave Peterson

date not correct in cell
 

Hi Dave

Yes that will do
(D1 is correct if that cell is not filled the formular will not
appears)

Strange situation same formular with other cells in the same sheet
are oke

Thanks
Ron





Dave Peterson schreef:

=IF(D1="";"";"The date is ";text(A1;"mm/dd/yyyy"))

Did you really mean to use D1 and A1?

wrote:

Hi
I formatted cell A1 to date cell
till sofar the date 01-11-06 appears as requested in that cell

When I copy A1 to B1 (B1=A1) it gives also the correct date

When I put in B1 the formule
=IF(D1="";"";"The date is ";A1) it shows The date is 39022

(programmed in Excel2003 and copied to Excel2000)
What is wrong
Please help
Thanks in advance
Ron

--

Dave Peterson