Hi there

I've been trying to use =DATEDIF(A1,TODAY(),"y") - A1 being my date of
birth, but when I activate the formel I get an error - high-lighting both the
A1 and TODAY - I'm a Danish user and the excel I'm using is in Danish vers.
2003 - does that have anything to do with it??? And what cell format do I
need to use in A1 - 'standard' is my first choice but I still get an error!!!

Regards
Alberte

Worked for me in English. Try with ; instead of ,
--
Don Guillett
SalesAid Software

"Alberte" wrote in message
...
Hi there

I've been trying to use =DATEDIF(A1,TODAY(),"y") - A1 being my date of
birth, but when I activate the formel I get an error - high-lighting both
the
A1 and TODAY - I'm a Danish user and the excel I'm using is in Danish
vers.
2003 - does that have anything to do with it??? And what cell format do I
need to use in A1 - 'standard' is my first choice but I still get an
error!!!

Regards
Alberte

hello Alberte,

you may have to use semi-colons instead of commas, try


=DATEDIF(A1;TODAY();"y")

format as general


"Alberte" wrote:

Hi there

I've been trying to use =DATEDIF(A1,TODAY(),"y") - A1 being my date of
birth, but when I activate the formel I get an error - high-lighting both the
A1 and TODAY - I'm a Danish user and the excel I'm using is in Danish vers.
2003 - does that have anything to do with it??? And what cell format do I
need to use in A1 - 'standard' is my first choice but I still get an error!!!

Regards
Alberte

Select result cell
Open Tools/Macro/Visual Basic editor/View/Immediate window
Type in activecell.Formula="=DATEDIF(A2,TODAY(),""Y"")"
Press enter

Excel will translate the English formula into Danish.

Regards,
Stefi




€žAlberte€� ezt Ã*rta:

Hi there

I've been trying to use =DATEDIF(A1,TODAY(),"y") - A1 being my date of
birth, but when I activate the formel I get an error - high-lighting both the
A1 and TODAY - I'm a Danish user and the excel I'm using is in Danish vers.
2003 - does that have anything to do with it??? And what cell format do I
need to use in A1 - 'standard' is my first choice but I still get an error!!!

Regards
Alberte

DATO.FORSKEL (for Danish version)


"Alberte" wrote:

Hi there

I've been trying to use =DATEDIF(A1,TODAY(),"y") - A1 being my date of
birth, but when I activate the formel I get an error - high-lighting both the
A1 and TODAY - I'm a Danish user and the excel I'm using is in Danish vers.
2003 - does that have anything to do with it??? And what cell format do I
need to use in A1 - 'standard' is my first choice but I still get an error!!!

Regards
Alberte

YES! that did it - both the translation to danish in the formel and the
semicolon, the result is:

=DATO.FORSKEL(B2;IDAG();"y") - where B2 is my date of birth

Thanks! :-)

"Teethless mama" skrev:

DATO.FORSKEL (for Danish version)


"Alberte" wrote:

Hi there

I've been trying to use =DATEDIF(A1,TODAY(),"y") - A1 being my date of
birth, but when I activate the formel I get an error - high-lighting both the
A1 and TODAY - I'm a Danish user and the excel I'm using is in Danish vers.
2003 - does that have anything to do with it??? And what cell format do I
need to use in A1 - 'standard' is my first choice but I still get an error!!!

Regards
Alberte

You are welcome! thanks for the feedback!
Stefi


€žAlberte€� ezt Ã*rta:

YES! that did it - both the translation to danish in the formel and the
semicolon, the result is:

=DATO.FORSKEL(B2;IDAG();"y") - where B2 is my date of birth

Thanks! :-)

"Teethless mama" skrev:

DATO.FORSKEL (for Danish version)


"Alberte" wrote:

Hi there

I've been trying to use =DATEDIF(A1,TODAY(),"y") - A1 being my date of
birth, but when I activate the formel I get an error - high-lighting both the
A1 and TODAY - I'm a Danish user and the excel I'm using is in Danish vers.
2003 - does that have anything to do with it??? And what cell format do I
need to use in A1 - 'standard' is my first choice but I still get an error!!!

Regards
Alberte