Date formatting in a formula??

  • Thread starter Thread starter Dan B
  • Start date Start date
D

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
 
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.
 
that worked. Thanks.


Dave R. said:
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.
Click to expand...
 
Back
Top