Date formatting in a formula??

[Dan B]

Hi,

I have 2 date fields in a spreadsheet that I have formatted as text so that
they can be exported to SQL via DTS. However, I need to use on of those
dates in another formula that requires a date format. Is there any way to
have my formula read it as a date even though it is text?

Thanks,
Dan

 

[Dave R.]

Dan, I think the datevalue function will do what you say.

If you have a cell A1 formatted as text which looks like 12/1/03

datevalue(a1) returns 37956 which is a date that can be added, etc. with
other date values.

 

[Dan B]

that worked. Thanks.

Dan, I think the datevalue function will do what you say.

If you have a cell A1 formatted as text which looks like 12/1/03

datevalue(a1) returns 37956 which is a date that can be added, etc. with
other date values.