Date Formats

[cindy]

I'm using a formula to look at two cells and return one
of them. One is a date and the other a number. (date of
birth or age). The problem I'm having is the result
needs to be formatted as a date or a number depending on
which cell the formula picks.

For example if there is a date of birth in cell a1 it
returns a1. If not it looks to b1 for the age.

From here I use this to upload into another program that
requires it to be formatted as a date if it is a date or
as a number if it is an age.

Any help will be greatly appreciated.

 

[Peo Sjoblom]

=IF(AND(A1=A2,A1<>""),TEXT(A1,"mm/dd/yy"),A3)

The date will be text though..

 

[Cindy]

Thank You. The text(a1,"mm/dd/yy") is exactly what I
needed.

Thanks so much for your help.