Help with Date formats

Tech-Archive recommends: Speed Up your PC by fixing your registry

I have a large SS. Dates were suplied in 4-21-1998 format. I need to calc the
difference between 2 dates. but the formula =MONTH(A3)-MONTH(A2) wont work. I
suspect that the supplied dates are in text format or something since I can't
change the formats using the Format/Cells/Dates method. How can I eiather get
the formula to work, or change the date format of the supplied data?

(Someone did reply to this earlier, but the link didn't connect.)
Thanks

Ron S
.

Relevant Pages

  • Re: Problems with debugging Lists
    ... The pprint function in the pprint module ... the name `foo` becomes available to be used in that module -- ... repr works as you say and I had some complaints, it wont format the output. ... One time work another reload wont work. ...
    (comp.lang.python)
  • Re: datevalue
    ... Your first two values were within single quotes and hence they wont work. ... On the third format, am not sure of the reason why it doesnt work, but your date format should be in sync with your default date format set in the Regional settings. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: "Currency" format lost in subform.
    ... As far as I can recall, you would need to use the format function to force ... the format in the underlying query for the combobox or the list box. ... It wont work when it is a subform it seems. ...
    (microsoft.public.access.queries)
  • Dating Advice
    ... Now there are 7150 records and I cannot really alter the date format ... to conform with the mysql YYYY-MM-DD format. ... format it wont work. ... in DD/MM/YYYY and to do its magic and work as if it was the norm. ...
    (comp.lang.php)
  • Re: starting with OpenOffice base
    ... OpenOffice Calc, but this now exceeds Calc capacity, this is the only ... How am I to import a .csv ";" separated text file into base? ... 1.Export the desired data from the source database in a text format. ...
    (comp.os.linux.misc)